Manuals/calci/MAX1

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