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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.