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

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

"Lulu" wrote in message
...
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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Lulu" wrote in message
...
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

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.

--
Regards,
Tom Ogilvy



"Lulu" wrote in message
...
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