Forum Discussion
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 to update it so that when the cells it pulls from are empty, the formula doesn't populate. Currently, when no data is entered in the cells the formula pulls from, it default-populates to 0.10.
Any help is appreciated, thank you!
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),"")
5 Replies
- The data hasn't yet been entered - until the data is entered, i don't want to see the formula - but issue has been fixed, thank you for your input!
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...)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),"")- This worked like a charm, thank you soo much!
