Brian

In D2 enter

=IF(B2<500,"RED",IF(B2<1000,"Orange",IF(B2<1500,"G reen","Blue")))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


wrote in message
oups.com...
I've been pounding my head against my desk all morning trying to figure
this out, so this in where you all come in. Seems like it should be
simple, but I'm not getting it.
I want to evaluate the value in Column B and if certain criteria are
met, then place a category in column D. Here's what I want to
accomplish.
If B2<500 then place "RED" in Column D.
If B2 is between 500-1000 then place "Orange"
If B2 is between 1000-1500 then place Green
If B2 is 1500+ then place Blue.

I might just be overthinking, but I just can't seem to get it all the
way through testing each test.
Any help would be greatly appericated.
THANKS!