If cell is 0 or blank... - TechRepublic
Question
June 10, 2009 at 09:50 AM
jillym

If cell is 0 or blank…

by jillym . Updated 16 years, 7 months ago

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 discussion is locked

All Comments