如何在输入数据前保持单元格为空？现有IF公式优化咨询

Hey there, I get exactly what you're looking for—you want your formula to only show the "Yes/No" result once all three cells (E50, E51, E52) have been filled out, right?

Your original formula will always return either the "material" or "not material" message, even when the cells are empty. To fix this, we just need to add a check first to see if any of the required cells are blank. Here are two straightforward ways to do it:

Method 1: Using ISBLANK + OR #

This checks if any of E50, E51, or E52 is empty. If yes, returns an empty string; otherwise runs your original logic:

=IF(OR(ISBLANK(E50), ISBLANK(E51), ISBLANK(E52)), "", IF(AND(E50="Yes", E51="Yes", E52="Yes"), "Yes, the effect is material", "No, the effect is not material"))

Method 2: Using COUNTA #

This counts how many of the three cells have content. If fewer than 3 are filled, returns empty; else proceeds with your check:

=IF(COUNTA(E50:E52) < 3, "", IF(AND(E50="Yes", E51="Yes", E52="Yes"), "Yes, the effect is material", "No, the effect is not material"))

Both methods work great—pick whichever feels more intuitive to you. Once all three cells have values entered, your original "Yes/No" logic will kick in as expected.

内容的提问来源于stack exchange，提问作者ASE