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.