Easy IF question - I'm rusty :(

[chickadeejen]

Hi,

I know this is very easy - but I haven't used Excel for ages....

In Col A - I have a total eg. 1.75

In Col B - I would like to state if this number (1.75) falls into a criteria of 'small, med or large'.

Here's the criteria;
Small = <1.5
Med = between 1.5 and 2.5
Large = >3

I would like in Col B, to state the word ' Small, Med or Large'.

Can anyone help?

Thanks
Jen

 

[VoG]

Perhaps

=LOOKUP(A1,{0,1.5,3},{"Small","Med","Large"})

 

[chickadeejen]

That works great!

Thank you!
Jen