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),"")
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!