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