multiple if condition

[aeduj_17]

Hi all,

I'm formulating a formula like this:

IF (BI2="Run") then
IF(L2<=1;"X-Small")
IF(L2<=3;"Small")
IF(L2<=10;"Medium")
IF(L2<=20;"Large")
ELSE "X-Large"

Can you please help me use this into right excel formula.

Thanks in advance.
Any help is appreciated.

 

[pjmorris]

Hi,

Firstly welcome to the forum.

Try this: =if(B12="Run";IF(L2<=1;"X-Small";IF(L2<=3;"Small";IF(L2<=10;"Medium";IF(L2<=20,"Large";"X-Large"))));"")

HTH

 

[aeduj_17]

Thank you pjmorris! It works perfectly with what I want.
Thank you also for welcoming.
It's nice to be here.

 

[pjmorris]

delighted it worked and thanks for the feedback.

As a thought for the future, note that you use ';' as function parameter separator whereas most regions use ',' - I noticed the difference in your original post. Just something to be aware of.