Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
    
what are the x and y cell values? – jer.salamon Jul 31 '10 at 22:53
up vote 1 down vote accepted

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.

share|improve this answer
    
Thanks! LOOKUP was the thing I needed. – kdl Aug 1 '10 at 12:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .