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

30,990 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