Combining Multiple IF statements to translate Symbols
Hi-
I created a formula that turns the 5 Star rating system into a points value.
1 Star = 10 points, 2 Stars = 20 points, etc.
I want to combine all those IF statements into each row so that it auto returns the correct value. I've tried:
=IF(Rate@row = "One", "10”),(Rate@row = "Two", "20”),(Rate@row = "Three”, “30”),(Rate@row = “Four”, “40”),(Rate@row = “Five”, “50")
But I get unparsable. Thanks in advance.
Answers
-
Hey @Jessica Fisher
When nesting IFs, leave the IF open so that both the true and false (if any) will execute. In this case the next IF is part of the false statement to the preceeding IF. Note that the IFs close , one by one, at the very end of the formula.
=IF(Rate@row = "One", 10, IF(Rate@row = "Two", 20, IF(Rate@row = "Three”, 30, IF(Rate@row = “Four”, 40, IF(Rate@row = “Five”, 50)))))
cheers,
-
Hi @KDM thank you, sadly I'm still getting unparseable with that solution. Any other thoughts?
-
Perhaps it is just an illusion from the screenshot - are your quote marks all the same? Some look different in the pic. Be sure they aren't the curly quotes.
This is working on my test sheet
=IF(Rate@row = "One", 10, IF(Rate@row = "Two", 20, IF(Rate@row = "Three", 30, IF(Rate@row = "Four", 40, IF(Rate@row = "Five", 50))))) please just copy and paste
Let me know
Kelly
-
@KDM Thanks - I had copy/pasted the first time too but this time it worked. Something just didn't take I guess. Thanks so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!