Manuals/calci/DMAX

DMAX(db,fld,cri)

where db is the range of cells that makes up the list or database,

fld shows which column is used in the function and

cri   is the range of cells that contains the conditions that we specify.

---

 It gives the largest number in a column of a list or database that matches conditions we specify.

---

DMAX

---

 

[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]

[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]

[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 ]

[javascript:ToggleDiv('divExpCollAsst_4') R1 Name Age Salary ]

[javascript:ToggleDiv('divExpCollAsst_4') R2 <30 ]

[javascript:ToggleDiv('divExpCollAsst_4') R3 >40 >5000]

[javascript:ToggleDiv('divExpCollAsst_4') R4 Name Age Salary]

[javascript:ToggleDiv('divExpCollAsst_4') R5 John 34 5500 ]

[javascript:ToggleDiv('divExpCollAsst_4') R6 Bill 35 6500 ]

[javascript:ToggleDiv('divExpCollAsst_4') R7 Clark 29 7000 ]

[javascript:ToggleDiv('divExpCollAsst_4') R8 Bob 45 9000]

[javascript:ToggleDiv('divExpCollAsst_4') R9 Susan 37 4000]

[javascript:ToggleDiv('divExpCollAsst_4') R10 Jill 45 8000 ]

[javascript:ToggleDiv('divExpCollAsst_4') I.e =DMAX(C1R4:C3R10,”Salary”,C1R1:C2R3) is 9000]

---

Syntax

---

Examples

---

Description

---

	Column1	Column2	Column3	Column4
Row1	Name	Age	Salary	9000
Row2		<30
Row3		>40	>5000
Row4	Name	Age	Salary
Row5	John	34	5500
Row6	Bill	35	6500
Row7	Clark	29	7000
Row8	Bob	45	9000
Row9	Susan	37	4000
Row10	Jill	45	8000

File:Calci1.gif

---