cell minimum value of zero ?
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
|