DMAX

[Guest]

I copied the help example from the help windows on DMAX. I get this complain:
#value! what wrong? The following does not look right. You can copy the text
from the help menu into excel and you will see that the example in the excel
did not help me at all.

1
2
3
4
5
6
7
8
9
10
A B C D E F
Tree Height Age Yield Profit Height
="=Apple" >10 <16
="=Pear"
Tree Height Age Yield Profit
Apple 18 20 14 105.00
Pear 12 12 10 96.00
Cherry 13 14 9 105.00
Apple 14 15 10 75.00
Pear 9 8 8 76.80
Apple 8 9 6 45.00
Formula Description (Result)
=DMAX(A4:E10,"Profit",A1:A3) The maximum profit of apple and pear trees.
(105)
=DMIN(A4:E10,"Profit",A1:B2) The minimum profit of apple trees over 10 in
height. (75)

 

[fredg]

I copied the help example from the help windows on DMAX. I get this complain:
#value! what wrong? The following does not look right. You can copy the text
from the help menu into excel and you will see that the example in the excel
did not help me at all.

1
2
3
4
5
6
7
8
9
10
A B C D E F
Tree Height Age Yield Profit Height
="=Apple" >10 <16
="=Pear"
Tree Height Age Yield Profit
Apple 18 20 14 105.00
Pear 12 12 10 96.00
Cherry 13 14 9 105.00
Apple 14 15 10 75.00
Pear 9 8 8 76.80
Apple 8 9 6 45.00
Formula Description (Result)
=DMAX(A4:E10,"Profit",A1:A3) The maximum profit of apple and pear trees.
(105)
=DMIN(A4:E10,"Profit",A1:B2) The minimum profit of apple trees over 10 in
height. (75)

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.