PDA

View Full Version : Delete data without deleting the formula



mahmoud-lee
12-08-2013, 07:30 PM
I want to delete the data of this column without deleting the formula is this possible?

jolivanes
12-09-2013, 01:13 AM
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.

=IF(OR(B3="",C3=""),"",SUM(B3:C3))

rollis13
12-09-2013, 02:49 AM
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.

mahmoud-lee
12-09-2013, 03:29 AM
Thanks to all