Help with IF(AND formula

Bwoods113

I have something wrong in my formula and im not sure what it is. I am trying to have the column say yes or no to the statement. My formula is below and a screenshot of my sheet for reference.

=IF(AND([GPS Tracked]@row=yes, [GPS installed?]@row=no), "yes", "no")

Thank you for your help.

Brandon

Genevieve P.

Hi @Bwoods113

Any time you're typing text into a formula you'll want to surround it in quotes. Try this:

=IF(AND([GPS Tracked]@row = "Yes", [GPS installed?]@row = "No"), "Yes", "No")

Cheers,

Genevieve