cell minimum value of zero ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
How do you get that? I get 0, as expected. One cell must have an error. You
can hide it with

=IF(ISERROR(A1*B1),0,A1*B1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top