More if then logic

[DJ]

Here's another one for ya--

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

 

[Sam Wilson]

Not too sure what you mean max of, but this one will return the letter x,y or
z:

=IF(RANK(F4,$F$4:$F$14)<7,"X",IF(RANK(F4,$F$4:$F$14)<23,"Y","Z"))

And this one will return the max of the range in question, 50% of it, or 0%
of it

=IF(RANK(F4,$F$4:$F$14)<7,MAX($F$4:$F$14),IF(RANK(F4,$F$4:$F$14)<23,0.5*MAX($F$4:$F$14),0))

You need to change the F4 and your $F$4:$F$14, obviously.

Sam

 

[DJ]

the rankings aren't values in the table, rather they are just arbitrary
numbers (1-22)...