Issue with #VALUE!

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
 
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top