If number is beween X and Y then ... on multiple conditions

[TTUK]

Hi All,

I really need some simple help on this one ...

............F .......G .................H .......I

1......RATE</SPAN>	PREF </SPAN>	SCORE</SPAN>
2......S</SPAN>	Excellent</SPAN>	86</SPAN>	100</SPAN>
3......A*</SPAN>	Very Good</SPAN>	71</SPAN>	85</SPAN>
4......A*</SPAN>	Good</SPAN>	56</SPAN>	70</SPAN>
5......B</SPAN>	Improvement </SPAN>	41</SPAN>	55</SPAN>
6......C</SPAN>	Unsatisfactory</SPAN>	26</SPAN>	40</SPAN>

<TBODY>
</TBODY>

Example
If in DB112 the number is 60 in CT112 i need it to show A*

If in DB112 the number is 99 in CT112 i need it to show S


Note, the numbers are split in to Columns H and I

Thank you,

TTUK

 

[Momentman]

Maybe you could be more explanatory.

Where or what are DB112 and CT112?

 

[Michael M]

one way

=IF(DB112<26,"",IF(DB112<41,F6,IF(DB112<55,F5,IF(DB112<70,F4,IF(DB112<85,F3,IF(DB112<101,F2,""))))))

 

[TTUK]

Hi Momentman,

DB112 is an automatically calculated user score.
CT112 is when I need it to say based upon the score in DB112, what is the RATE given for the score.

It's like when you are taking an exam at school, if the person scores between 41 and 55 in a Test (their score given in DB112) then from the table of Scoring (my table above), they receive the Rating of 'B' ... which will be shown in CT112.

Hope this helps,

TTUK

 

[TTUK]

one way

=IF(DB112<26,"",IF(DB112<41,F6,IF(DB112<55,F5,IF(DB112<70,F4,IF(DB112<85,F3,IF(DB112<101,F2,""))))))

Hi Michael M,

This works wonderfully! Thank you very much!

TTUK

 

[Michael M]

Glad it worked...