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!
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! Read More