| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another IF Question
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Threaded Mode
