I want to delete the data of this column without deleting the formula is this possible?
Printable View
I want to delete the data of this column without deleting the formula is this possible?
The data is the result of the formula, so no, you can't
Clear the values in Columns B and C and use this Formula.
PHP Code:
=IF(OR(B3="",C3=""),"",SUM(B3:C3))
You can hide the entire column or change the cell's text colour to White but, as said, you can't clear the result of the formula unless you clear column B and C.
Thanks to all