equation help in excel

[Guest]

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

 

[Chip Pearson]

Rather than an IF THEN statement, you should use VLOOKUP. See
help for more information, and post back here if you have any
questions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bernard Liengme]

Small typo here? Should 1.02 be 1.2?
Try this =IF(AND(A1>=1.009,A1<=1.059),5,IF(AND(A1>=1.06,A1<=1.2),6,"Error"))
best wishes

 

[Tom Ogilvy]

The number shown don't have a pattern. 1.020 is less than 1.060 so there
are no numbers between as shown

If you are increasing the value by .05 each time

=Trunc((number-1.009)/.05) + 5

might be close to what you want.