More if then logic

[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?

 

[Jacob Skaria]

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

If this post helps click Yes

 

[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