IF Function help
I am attempting to use a nested IF statement that assigns a number based on a dropdown selection.
Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection in the next column.
=IF([Care Training Impact]1 = High, "60", IF([Care Training Impact]1 = Medium, "35", "2"))
I receive an 'unparseable' error. Any thoughts on what can be done to return what I am looking for?
Comments
-
High and Medium should be in quotes like this:
=IF([Care Training Impact]1 = "High", "60", IF([Care Training Impact]1 = "Medium", "35", "2"))
Also, if you want those values to be actual numbers... remove the quotes around the numbers like this...
=IF([Care Training Impact]1 = "High", 60, IF([Care Training Impact]1 = "Medium", 35, 2))
That way the numbers won't be converted to text and will be able to be summed or used in calculations without converting them back into numbers.
-
=IF([Care Training Impact]1 = "High", 60, IF([Care Training Impact]1 = "Medium", 35, 2))
-
Thanks, I finally have a number showing!
Issue now: When I change the dropdown value from Medium to High, Low or None, the number doesn't change. Anything I'm missing?
-
Adding @row instead of a specific row number will look at the columns for the current row you are on.
-
This worked perfectly, thank you!!
-
Great! I'm glad I could be of assistance.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives