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
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.