View Single Post
  #6  
Old 2nd October 2004, 11:11 AM
foggy foggy is offline
Member
 
Join Date: Jan 1970
Location: South West Sydney
Posts: 37
Default

To get rid of the "div by 0" problem, have each of the formulas in these cells (or all cells) first refer to the first collumn that you start putting info in and if that collumn has nothing in it then the cell in question can display "0" eg.

=if(a1=0,0,formula)

where "formula" is the equation you want worked out

Then, when your "Max" and "Min" formulas work something out "zero" will obviously be lower or higher than the other amounts.
Reply With Quote