Round 2, best way to make a cell blank until another cell is populated?

Last glitch I just thought of and thanks to FD and Ker, they made this easy.

The second glitch I just thought of was..............how do stop the result of cell showing until the referenced cell has data in it? I have IF statements in 5 rows 500 lines 750 lines deep. These prepopulate "YES" or "NO" based off of a reference cell, but I don't want to have some random YES, or ### there until that referenced cells data has been entered. G, H, I, J, K

Under the Master tab if you choose to open. The IF statement in the cell currently in case you do not want to look is: =IF(K3>=40,"Yes","No") so I want the cell to be blank if K3 hasn't been populated yet..............if that makes sense.

Best way to do this?

I get at too many arguments error.

=IF(K3>=40,"Yes","No") is what is in the cell now, so now I'm putting =IF(k3="","", K3>=40,"Yes","No") which obviously will have issues.