| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do create a formula to evalute a # to return 1 of 4 conditions
I have to evaluate a single number in a single cell and return a value based
on that number. How do I build a formula to do the following? If the number is < 500, I need to return "Non-Target" If the number is = 500 but < 1500, I need to return "Low" If the number is = 1500 but < 3500, I need to return "Medium" If the number is = 3500, I need to return a value of "High" How do I build this formula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can create a formula to add data from 1 worksheet to another? | Excel Discussion (Misc queries) | |||
| Why does my formula return zero? | Excel Discussion (Misc queries) | |||
| how to create a multiple conditional formula | Excel Discussion (Misc queries) | |||
| create a chart with a formula | Charts and Charting in Excel | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Threaded Mode
