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?
Help Article Resources
Check out the Formula Handbook template!