Formula Not Working. Turning Sizes into Numbers

Marcel Hovsepian

Hello,

I am trying to write a simple formula where I translate a size value into a number.

For example in my column called "Size":

I want to create a formula that turns the following size into corresponding numbers in another column. 

XS = 1, S = 2, M = 3, L = 5

My formula is as follows, but doesn't work?

=IF([Size]1 = "XS", 1), IF(([Size]1 = "S", 2)), IF(([Size1] = "M", 3)), IF(([Size1] = "L",5))

 

Thanks for any help,

Marcel

Andrée Starå

Hi Marcel,

You were close. It looks like you have to many parenthesis in a few places.

Try something like this.

=IF(Size@row = "XS"; 1; IF(Size@row = "S"; 2; IF(Size@row = "M"; 3; IF(Size@row = "L"; 4))))

The same version but with the below changes for convenience.

=IF(Size@row = "XS", 1, IF(Size@row = "S", 2, IF(Size@row = "M", 3, IF(Size@row = "L", 4))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Marcel Hovsepian

Thanks so much Andrée . The formula worked.

Much appreciated,

Marcel

Andrée Starå

Hi Marcel,

You were close. It looks like you have to many parenthesis in a few places.

Try something like this.

=IF(Size@row = "XS"; 1; IF(Size@row = "S"; 2; IF(Size@row = "M"; 3; IF(Size@row = "L"; 4))))

The same version but with the below changes for convenience.

=IF(Size@row = "XS", 1, IF(Size@row = "S", 2, IF(Size@row = "M", 3, IF(Size@row = "L", 4))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Marcel Hovsepian

Thanks so much Andrée . The formula worked.

Much appreciated,

Marcel

Andrée Starå

Excellent!

Happy to help!