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)")))
Answers
-
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
-
For some reason it turns my IF statement unperishable.
-
got it Dave, just needed to delete the 1 in between the @rows. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives