multiple And / else in and If statement

[bwian1234]

This has been driving me mad, can someone help please?
I am looking for a formula that will display 1 of 4 possible outcomes this is what I'm after.

If A1 >1 but <10 then "Blue" else if A1 >9 but less than 100 then "Red" else if A1 >99 and less than 200 then "Green" If A1 >199 then "black"

Can anyone help please?
thanks
(oh, I'm using Excel 2010)

Bwi.

[63falcondude]

Hello and welcome to the forum.

Try something like this:

=LOOKUP(A1,{1,10,100,200},{"Blue","Red","Green","Black"})

[Pete_UK]

If you are looking for a multiple IF solution (also referred to as a Nested IF), then you could do it this way:

=IF(A1<10,"Blue",IF(A1<100,"Red",IF(A1<200,"Green","Black")))

Hope this helps.

Pete

[bwian1234]

Thanks great, thanks

[63falcondude]

Glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.