| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN formulas
I have a series of FROM/TO ratings in a table (see below). I want to build a
formula for my spreadsheet that will automatically capture the ADJ Rating whenever the number falls within the From/To Range. Any suggestions? Thanks in advance. Range (from / to) Adj Rating 0.01 0.95 As Is 0.96 0.99 1.00 1.00 1.03 1.05 1.04 1.05 1.10 1.06 1.09 1.15 1.10 1.15 1.20 1.16 1.20 1.25 1.21 1.25 1.50 1.26 3.00 2.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Threaded Mode
