Home |
Search |
Today's Posts |
#1
|
|||
|
|||
equation help in excel
I need help making an equation.
I have a range of numbers, e.g. 1.009-1.059,1.060-1.020..... I beleive I need an IF THEN equation. If a number falls in the range between e.g. 1.009 and 1.059, I have get the value, e.g. 5, if the number fall between 1.060 and 1.020 I get the value 6. This pattern could continue forever. Can anyone help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
calculate non linear equation lines using excel | Excel Discussion (Misc queries) |