If formula Help Required

[yrajnani]

Hi,

I have a doubt in using an if formula. The formula should just suffice the below conditions:

If A2 is less than 100%, it should comment "short supply"
If A2 is between 100%-200%, "Adequate Stock"
If A2 is greater than 200% It should be excess stock.

Could you please help.

Thanks,
Yogita.

 

[yrajnani]

To add to this one more condition please, if A2 is #div/0! error, then the field should be blank.

Any and every help will be highly appreciated.

Thanks,
Yogita

 

[Manohar M G]

Hi,

What is #div/0..?

 

[DeepakS]

=IF(A2<=100%,"short supply",IF(AND(A2>100%,A2<=200%),"Adequate Stock","Excess Stock"))

 

[Andrew Poulsom]

How about?

=IF(ISNUMBER(A2),IF(A2>2,"Excess Stock",IF(A2>1,"Adequate Stock","Short Supply")),"")

 

[yrajnani]

Thanks Manohar, that is an error when I am dividing the A2 Cell with something that has 0..

Regards,
Yogita

 

[yrajnani]

Wow, it worked.
Thanks a ton Andrew....