Manuals/calci/MAX1
Jump to navigation
Jump to search
'
MAX(n1,n2,n3.........)
MAX (R1, R2,external R1....
............)
There is no limit to how many parameters pass to MAX.
This function returns the largest number from set of numbers.
Parameters can be numbers,array or references that contain numbers.
Parameters have no numbers, MAX returns 0.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 17 | 2 | 9 |
| Row2 | 7 | 5 | ||
| Row3 | 12 | 8 | ||
| Row4 | 17 | 9 | ||
| Row5 | 0 | |||
| Row6 |
MAX
Lets see an example in
=MAX(B2:B5)
Largest number from (2,7,12,17) is 17.
Consider another example
=MAX(2,5,8,9,0)
MAX return the largest number from(2,5,8,9,0) is 9.
Syntax
Remarks
Examples
Description