More if then logic

  • Thread starter Thread starter DJ
  • Start date Start date
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?
 
Try the below
=LOOKUP(A1,{0,1,7,13,23},{"","X","Y","Z",""})

If this post helps click Yes
 
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
 
Back
Top