Thread
:
cell minimum value of zero ?
View Single Post
#
1
Posted to microsoft.public.excel.misc
JcR
Posts: n/a
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
Reply With Quote