Convert word (from single-select drop-down) to number

anne0225

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!

Malaina Hudson

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

anne0225

Thanks Malaina, that did it!

Malaina Hudson

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

anne0225

Thanks Malaina, that did it!