Forum Discussion
Solved
How to avoid a #value error due to source cell being blank but containing another formula
Hi, I am using the following formula: =IF(AND(D3="",E3="",F3=""),"",D3+E3+F3) to sum three cells but to return a blank (rather than 0) if all source cells are empty. This works fine in other areas ...
amkdil Change the formula to:
=IF(AND(D3="",E3="",F3=""),"",SUM(D3:F3))SUM ignores the text value "" to may result from the formula in D3.
amkdil Change the formula to:
=IF(AND(D3="",E3="",F3=""),"",SUM(D3:F3))
SUM ignores the text value "" to may result from the formula in D3.
- Thank you so much for your quick and helpful response!
