K
Ken H
If you are adding a series of cells and one of them has
defaulted to a value of "#VALUE!" how do you have Excel
ignore this cell and give it a default value of zero? For
example,
A1 = 2
B1 = 3
C1 = #VALUE! (due to another cell having a "NA" value)
I want A1+B1+C1 to equal 5, basically ignoring the C1
cell in this case.
Thanks - Ken
defaulted to a value of "#VALUE!" how do you have Excel
ignore this cell and give it a default value of zero? For
example,
A1 = 2
B1 = 3
C1 = #VALUE! (due to another cell having a "NA" value)
I want A1+B1+C1 to equal 5, basically ignoring the C1
cell in this case.
Thanks - Ken