View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AlexKoL AlexKoL is offline
external usenet poster
 
Posts: 2
Default DMAX wrong calculation

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.