View original (French)

Excel formula if contains YES or NO

Hope -  
PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   -

Hello everyone,

I'm desperately looking for a formula that allows me to send reminders if I don't get a response, for example:

In cell G5, I need to write YES or NO if I've received a response from my recipient, and depending on the answer, cell H5 should specify whether it's OK or REMINDER. I've tried different formulas but either there's a naming issue, or too many arguments, etc.

Can you please help me, thank you in advance.

1 answer

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     

    Hello

    I don't know if I understood everything;

    =IF(G5="YES","OK","REMINDER")

    Best regards

    0