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