# Software

## Question

Locked

### If cell is 0 or blank...

By ·
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.

Thread display: Collapse - | Expand +

Collapse -

### The function is "ISBLANK"

by 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 In reply to The function is "ISBLANK"

Collapse -

### IF will work

by 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

## Related Discussions

• 5

Titan102 ·

• 2

#### How to configure Outlook to automatically take presence info from MS Teams

JSstaticcontrol ·

• 5

GizzyHD ·

• 2

bluenite1 ·

• 3

vassy101 ·