Col H should display "Yes" if the value of Col F is greater than 25.
If the value of Col F is less than 25 but not blank or "-", Col H should show "No".
If Col F is blank or "-", Col H should be blank.
I have tried this formula however the result is False.
=IF(F9="-","-",IF(F9>25,"Yes",IF(G9="Yes","No",IF(F9<25,"No"))))
How can I combine these multiple criteria into a single Google Sheets formula?

Aucun commentaire:
Enregistrer un commentaire