I cannot convert my if statement to a column formula

karimo6

I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement.

=IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico", "01-440-0189 (MX)")))

DKazatsky

@karimo6

Try this: =IF(Country1@row = "US", "01-440-0187 (US)", IF(Country1@row = "Canada", "01-440-0188 (CA)", IF(Country1@row = "Mexico", "01-440-0189 (MX)", "")))

Hope this helps,

Dave

karimo6

For some reason it turns my IF statement unperishable.

karimo6

got it Dave, just needed to delete the 1 in between the @rows. Thank you!