More if then logic
 

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?

More if then logic
 

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

If this post helps click Yes
---------------
Jacob Skaria


"DJ" wrote:

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?

More if then logic
 

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
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"DJ" wrote:

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?