I want to delete the data of this column without deleting the formula is this possible?
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))
Last edited by bakerman; 12-10-2013 at 08:24 AM. Reason: Tags added
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.
Last edited by rollis13; 12-09-2013 at 02:52 AM.
Thanks to all
Bookmarks