Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formula for expressing multiple greater/less than
I am trying to construct a formula that will be based on the result of
an adjoining cell. I need to point to specific cell depending on what the number is in that adjoining cell. So for example: If D1 = 0 or 1 - point to B21 If D1 = 2, 3, 4, or 5 - point to B22 If D1 = 6,7,8,9, or 10 - point to B23 and so on... Rather than listing all of those variables, I know I should be able to write it as equal to/greater than, but less than. I just don't know how to express as a formula. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to determine if multiple dates are "greater than" one date | Excel Worksheet Functions | |||
Expressing a number in words | Excel Discussion (Misc queries) | |||
Expressing a number in words | Excel Worksheet Functions | |||
Expressing percentages in Excel | Excel Discussion (Misc queries) | |||
expressing minutes negatively | Excel Discussion (Misc queries) |