Issue with #VALUE!

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

In cell H13 I get #VALUE! The formula in H13 is H9+1
In cell H9 I have =IF(D3=0,"",D3+179)

Is there a way to stop #VALUE! and just show a blank cell?

thanks
 
This means that H9 is non-empty and contains a non-numeric value. So I'm
guessing that H9 evaluates to "" (an empty string).

You could try this in H9:
=IF(D3=0,0,D3+179)
But this will show a 0 instead of ""

If showing a 0 is not possible, you could use this in H13:
=if(isnumber(h9),h9+1,"")
 
Back
Top