Using excel 2010 I would like to clear a cell but keep the formula.
Current formula in H7, =IF(F7="","",F7-G7) Note: F7 is a date entry and G7 is, =TODAY() What I would like to do is in when F7 has a date entry I would like to clear H7 when the word "COMPLETE" is typed into cell K7 but keep the formula in H7.
I dont want to use a VBA as I would like to use this formula randomly going down 1,000 rows same columns.
Current formula in H7, =IF(F7="","",F7-G7) Note: F7 is a date entry and G7 is, =TODAY() What I would like to do is in when F7 has a date entry I would like to clear H7 when the word "COMPLETE" is typed into cell K7 but keep the formula in H7.
I dont want to use a VBA as I would like to use this formula randomly going down 1,000 rows same columns.