|Your question doesn't make sense.|
The 2 things you have mentioned, change the value of cell C2 and an IF statement in A1 returns "Deleted" are 2 separate events.
An IF statement in any given cell won't prevent you from changing the contents of another cell, so I'm not sure what you asking about.
Please provide some more details.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.