amending some code to include an if clause.

Good afternoon.

I have some code below which as you can see puts the word "closed" into col g when a value is entered into col AF. This is fine however, I am trying to amend to code slightly to include.... if the status of col G is "Re-opened" and a date is entered into AF then G should say "re-opened closed"

Please Login or Register  to view this content.

Thanks for looking

Hiya S. Sorry for the delay in responding. This works fine. Thanks for that and thank you for taking the time to help.