CLEAR CELL Formula

[jaxs2009]

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.

 

[Michael M]

Do you mean like this

=IF(K7="COMPLETE","",IF(F7="","",F7-G7))

 

[jaxs2009]

Ah man, I was on the right track but I had the =IF(K7="COMPLETE","" after the original formula =IF(F7='',"",F7-G7)

Thank you, your answer is working great, very much appreciated.

 

[Michael M]

Glad to help..