writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: + Line 22:
Line 23: − + − + − + − + − + + − | class="sshl_f" | 13 + − | class="sshl_f" | 13.5 + + + + + +
no edit summary
MAX(10,40,5,2,100) ''returns 100''
MAX(10,40,5,2,100) ''returns 100''
MAX(-3,0.02,TRUE,-7) ''returns 1''
MAX(-3,0.02,TRUE,-7) ''returns 1''
{| id="TABLE1" class="SpreadSheet blue"
{| id="TABLE1" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" | 15
| class="sshl_f" | 0.02
| class="sshl_f" | 32
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="odd"
| class="sshl_f" | 20
| class="sshl_f" | 0.5
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="even"
| class="sshl_f" | 3
| class="sshl_f" | -6
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="odd"
| class="sshl_f" | 32
| class="sshl_f" | TRUE
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="even"
| class="sshl_f" | 100
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="odd"
| class="sshl_f" | NAME
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}
|}
=MAX(A1:A6) : Calculates the maximum value in the range A1 to A6. TRUE and NAME are not counted. Displays ''100'' as a result.
=MAX(200,A3) : Calculates the maximum value between 200 and -6. Displays ''200'' as a result.
=MAX(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays ''2'' as a result.