View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
seedy3
 
Posts: n/a
Default calculation to ignore a 0 (zero) value

I have a series of calculations that I need to use the MIN formula. the
problem is that many of the cells can have a 0(zero) value and not just
blank. Is there a way to find the minimum value but ignore the 0's? Otherwise
the minimum is always 0.

Thanks