| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF Function
I have 10 possible ranges to create a cell value. I cannot use "IF" beyond 7
and I keep seeing suggestions to use "Lookup", but it's not working. I need some examples if they're out there. Here's what I'm trying to do: If the cell value in "X" is: <30, then value is 1 30-34 then value is 2 35-39 then value is 3 and so on.......... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
| Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
| multiple function in formula | Excel Worksheet Functions | |||
| IF function for multiple answers? | Excel Worksheet Functions | |||
| Multiple OR function | Excel Worksheet Functions | |||
Threaded Mode
