No that's not the case, it's because the OP didn't use it properly, ii
indeed he only want the max value in H3:H18 the obvious function would of
course be MAX. DMAX is a database function and it makes no sense using it on
a single range, however one way to use it would be this, H3 needs to be a
header, for instance "Amounts", in H1 put amounts and leave H2 empty, then
use the following
=DMAX(H3:H18,"Amounts",H1:H2)
will return the max value in H4:H18 regardless of formulas, but it doesn't
make any sense using it since MAX will do the work easier
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"PeterAtherton" wrote in message
...
Alex
It seems DMAX works on data not formulas. However MAx will work for you
e.g.
max(h3:h18)
Regards
Peter
"AlexKoL" wrote:
Hi there,
I am using Excel 9.0.7616 SP-3.
The calculation is very simple =DMAX(H3:H18,1,H3:H18), even though all
cells
in that small database have numbers the result says "0". All those cells
have
different formulas to calculate values from another cells. If I remove
all
formulas from those cells the DMAX functions works fine.