Hi I'm having trouble with some code that is designed to replace all the "Yes" in a column to "Reminder Sent". The Problem is that the column that it is looking under are all "if" statements that report yes if a certain condition is met. Is there a way for my code to recognize the Yes that the formula is reporting in order for it to change the text to just normal text.

Here's the simple version of the replace text code and the If statement I'm using in excel is: =IF(AND(TODAY()>K2+15,P2<>1,J2>=$J$300),"Yes","No")

Please Login or Register  to view this content.
Thank you very much