The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.

You can continue to find trusted guidance and support on the official Apple Support site.

We want to thank the community members who have contributed their time and expertise to help others with their Apple products.

iNanaz Author

Level 1

4 points

Display a blank cell IF one of the formula’s cells are blank

I’ve created a calculator sheet thing where I’ll input different values (depending on the results of some tests), so that there are some empty cells until I have the data to input. When there is no data inputted yet, there are these big red exclamations are all over the sheet which I dislike visually, and also, when there’s sometimes only partial data inputted, some of the calculations returned are not yet needed and are incorrect.

So what I think I need is a formula to do something like this, eg: If “cell x” is empty, then the “cell with formula” is also blank, instead of A) a massive red exclamation or B) an incorrect calculation because of incomplete data.

Thank you for any help!!

iPhone 4s, iOS 9

Posted on Jun 15, 2024 3:37 AM

Top-ranking reply

Badunit

Level 7

31,539 points

Posted on Jun 15, 2024 11:32 AM

If your inputs are B2, C2, and D2:

If you want the formula to start working when B2 gets filled in

=IF(B2="","",yourformula)

If you want it to start working only after all inputs have been filled in,

=IF(OR(B2="", C2="", D2=""),"", yourformula)

View in context

Display a blank cell IF one of the formula’s cells are blank

Similar questions