Share this article:

What it does: The MAX() function returns the largest value in a list of numbers.

Plain English: You may be working with a very large dataset, and can’t quickly find the largest number. You could sort the series, but what if the largest number keeps changing? Use the MAX function

Arguments: MAX(Number1,[Number2],[Number3)

  • Number1 – The first number you want to check
  • Number2 – Optional – The second number you want to check
  • Number3 – Optional – The etc. number you want to check