View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel Wizard.... NOT! Excel Wizard.... NOT! is offline
external usenet poster
 
Posts: 1
Default not calculating zero

I'm working on a 1600 line speadsheet, and I need to calculate the low price
in 6 of the columns. Then I need to take the low number of those 6 columns
and multiply that low bid by another column.

For one, how would that formula look, and for two, and my biggest problem,
is how do I make it not calculate several of the cells in the 6 columns that
are zero? I need it to ignore all the zero cells in the 6 columns.

Thanks for your help!