vendredi 11 septembre 2020

If statement based on multiple columns

In google sheets, how can I write an if statement that based on multiple columns, I can get a numerical value?

I have something like below that gives me a value if Yes or No,

=IF($G502="Yes",5,0)

If I want to say if $G502 and $H502 and $I502 and $k502 are all no, give me the value of 5?

Thanks!

Aucun commentaire:

Enregistrer un commentaire