mardi 6 août 2019

Logically combining multiple IFs

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?

Image of spreadsheet

Aucun commentaire:

Enregistrer un commentaire