writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 28:
Line 28: + + + + + + + − + + − + + − + + − + + − + + − + + − + + − + + − + + Line 80:
Line 96: − + − + − + − +
→Examples
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | A
| class="sshl_f" | B
| class="sshl_f" | C
| class="sshl_f" | D
|- class="odd"
| class="sshl_f" | 1
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
|- class="odd"
|- class="even"
| class="sshl_f" | 2
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" | <40
| class="sshl_f" | <40
| class="sshl_f" | >5000
| class="sshl_f" | >5000
| class="sshl_f" | >32
| class="sshl_f" | >32
|- class="even"
|- class="odd"
| class="sshl_f" | 3
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" | >30
| class="sshl_f" | >30
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 4
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 5
| class="sshl_f" | John
| class="sshl_f" | John
| class="sshl_f" | 34
| class="sshl_f" | 34
| class="sshl_f" | 5500
| class="sshl_f" | 5500
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 6
| class="sshl_f" | Bill
| class="sshl_f" | Bill
| class="sshl_f" | 35
| class="sshl_f" | 35
| class="sshl_f" | 6500
| class="sshl_f" | 6500
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 7
| class="sshl_f" | Clark
| class="sshl_f" | Clark
| class="sshl_f" | 29
| class="sshl_f" | 29
| class="sshl_f" | 7000
| class="sshl_f" | 7000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 8
| class="sshl_f" | Bob
| class="sshl_f" | Bob
| class="sshl_f" | 45
| class="sshl_f" | 45
| class="sshl_f" | 9000
| class="sshl_f" | 9000
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 9
| class="sshl_f" | Susan
| class="sshl_f" | Susan
| class="sshl_f" | 37
| class="sshl_f" | 37
| class="sshl_f" | 4000
| class="sshl_f" | 4000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 10
| class="sshl_f" | Jill
| class="sshl_f" | Jill
| class="sshl_f" | 45
| class="sshl_f" | 45
=DMAX(A4:C10,"Salary",D1:D2) : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32. ''Returns '9000''' as a result.
=DMAX(A4:C10,"Salary",D1:D2) : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32. <br>Returns '''9000''' as a result.
=DMAX(A4:C10,2,A1:A3) : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees. ''Returns '45''' as a result.
=DMAX(A4:C10,2,A1:A3) : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees. <br>Returns '''45''' as a result.
=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '45''' as a result.
=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. <br>Returns '''45''' as a result.
=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '9000''' as a result.
=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees. <br>Returns '''9000''' as a result.
==Related Videos==
==Related Videos==