mercredi 29 avril 2015

How to make an if statement with multiple conditions.

Basically I have two different columns; column G and H

I would like to make it so that if the Column H is greater than today's date Coloumn G equals "G" for good and if Column H is less than today's date Column G will equal "R" for not on track

=IF(H84<TODAY,"R","G")

My return is #NAME?

Aucun commentaire:

Enregistrer un commentaire