Forum Discussion
Solved
How to show blank cell, with an existing formula, when no data is available, yet
How can I get my cells to show blank, with an existing formula, until data in other cells is entered? This is my current formula =0.1*INT((5+(MOD(E3-D3,6)=0)+TEXT(E3-D3,"[m]"))/6) - I need t...
Hey baugustadt currently I'm learning excel as well and think I can help you out a bit. Im sure there is a way better option out there but for now this is what I got. Using the IF function right before your statement should be enough give it a try and let me know if that works.
=IF(D3<>"",0.1*INT((5+(MOD(E3-D3,6)=0)+TEXT(E3-D3,"[m]"))/6),"")
Excel doesn't return blank as a value. You may return empty string "" or zero formatting as, for example, #,##0.00;#-##0.00; Depends on what are going to do with result.
At the same time you may check if cell is blank or not using ISBLANK() or compare cell value with empty string, e.g. IF(A1="", "empty", "not empty").
Finally, update could be
=IF( OR(D3="", E3=""), "", YourFormula...)