Question

Locked

If cell is 0 or blank...

By JillyM ·
I have Microsoft Excel 2000. I can't get a formula to work correctly for me. I am trying to create a formula in cell I13 that if D13 is 0 to leave I13 blank, if D13 is not 0 then to add I12 + D13. Does that make sense? I have done much research and thought that if I did: =IF(blank(D13,0,I12+D13)it would work, but it does not work. Any ideas? Thank you.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

The function is "ISBLANK"

by neilb@uk In reply to If cell is 0 or blank...

And you've got a com,ma where you shouldn't have

=IF(ISBLANK(D13),0,I12+D13) will work

Neil :)

Collapse -

Thanks!

by JillyM In reply to The function is "ISBLANK"

Very helpful! It worked.

Collapse -

IF will work

by waltjohnson35 In reply to If cell is 0 or blank...

Probably the most simple formula is
=IF(D13=0,"",I12+D13)

You could also reverse the question
=IF(D13<>0,I12+D13,"")

WaltJ

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums