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)

"JcR" wrote in message
...
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