Convert word (from single-select drop-down) to number
Hi all. I've set up a sheet to capture information regarding a potential project. One of the columns is titled "Edition" and the drop-down options are "Professional", "Professional +" and "Enterprise". I've inserted a column to the right that I'd like to use to calculate the following:
Professional = 8
Professional + = 12
Enterprise = 16
What formula can I use in that column to spit out the number?
Thank you!
Best Answers
-
Hi, @anne0225 ,
Try this and see if it does what you need it to do.
=IF([test my work]@row >= 16, "Enterprise", IF([test my work]@row >= 12, "Professional +", IF([test my work]@row >= 8, "Professional", "")))
This should give you the result where value<8 will result in a blank, 8-11 will be Professional, 12-15 will be Professional +, and 16 and up will be Enterprise.
Cheers!
Malaina
-
Thanks Malaina, that did it!
Answers
-
Hi, @anne0225 ,
Try this and see if it does what you need it to do.
=IF([test my work]@row >= 16, "Enterprise", IF([test my work]@row >= 12, "Professional +", IF([test my work]@row >= 8, "Professional", "")))
This should give you the result where value<8 will result in a blank, 8-11 will be Professional, 12-15 will be Professional +, and 16 and up will be Enterprise.
Cheers!
Malaina
-
Thanks Malaina, that did it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!