jeudi 5 août 2021

Trying to combine two IF statements together in google sheets

I am basically trying to check if column F has a specific value and along with if column G also has a specific value, then return something. My code looked like this

=IF(F:F="Naveen",IF(G:G="YTS","working"),"not working")

This is returning "not working", even though both the specific values are present.

Sheet image

Can someone please help?

Aucun commentaire:

Enregistrer un commentaire