More if then logic

D

DJ

Here's another one for ya--

I'm creating a calculator that returns a value based on rankings. Values 1-6
should return X value, values 7-12 return Y value, values 13-22 should return
Z value.
X, Y and Z represent 100% of max, 50% of max and 0% of max respectively. Any
ideas?
 
J

Jacob Skaria

Try the below
=LOOKUP(A1,{0,1,7,13,23},{"","X","Y","Z",""})

If this post helps click Yes
 
J

Jacob Skaria

Missed to mention to add your rankformula to the below..formula

=LOOKUP(yourRankformulahere,{0,1,7,13,23},{"","X","Y","Z",""})

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top