View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JcR
 
Posts: n/a
Default cell minimum value of zero ?

I want the value of a cell to equal zero (0) or a positive number

"#N/A" is appearing now

a1 = b1* c1

If b1 or c1 = 0, I get "#N/A" in the cell

I want it to be a "0" when that happens

thanks