Issue with #VALUE!

[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

 

[Dave Peterson]

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,"")

 

[ss]

Thanks for your reply issue has now been sorted.
thank you