Forum Discussion
olliecoopersiddle
May 06, 2018Copper Contributor
Hiding duplicate Formula Cells Until a value has been input
I'm creating a sheet with 3 columns: date, running total, and invoice amount. When I input a new invoice amount it puts the new total in the running total box. I've just dragged the formula down...
- May 07, 2018
Hi,
You can prefix the formula in cell B3 with some conditions as follows:
=IF(OR(B2="",C2=""),"",B2-C2)
Regards
Haytham Amairah
May 07, 2018Silver Contributor
Hi,
You can prefix the formula in cell B3 with some conditions as follows:
=IF(OR(B2="",C2=""),"",B2-C2)
Regards
- olliecoopersiddleMay 07, 2018Copper ContributorPerfect! Thank You