Excel 2007: help with a formula

Question

I need to implement the following function/formula in Excel 2007 which would give me the following:

for x<0.68 y=0 for 0.68<=x<0.81 y=1 for 0.81<=x<1 y=2 for 1<=x<1.25 y=3 for x>1.25 y=4

Please advise.

Answer 1

You have two options:

1 - Make a very long string of nested IF statements.

2 - Use a lookup table. The lookup table is the best bet IMO. Check out directions HERE.