Using the IF Command

[Joe Coulter]

Hi

I am trying to automatically place Members in a Group depending on their
Score, i.e

If the Score is a value from 1 to 13 then Group A,
If the Score is a value from 14 to 26 then Group B,
If the value is a value from 27 to 39 then Group C.

My Worksheet looks like this :-

Column
A B C
Name Score Group
J Bloogs 6 A
J Brown 10 A
J Smith 29 C

I have been playing with this for ages and have now blown my brain,

I would greatly appreciate any help

Joe

 

[Pete_UK]

Try this in C2:

=IF(B2<=13,"A",IF(B2<=26,"B","C"))

and copy down. If you want to avoid using IFs, here's an alternative:

=CHAR(65+INT((B2-1)/13))

Hope this helps.

Pete

 

[Joe Coulter]

Pete

Thank you for your reply, Worked a Treat, dunno whats going on in my head,
must be overworked or something, its so simple.

Anyway, Thanks Again

Joe

 

[Pete_UK]

You're welcome, Joe - thanks for feeding back.

Maybe it was Monday morning for you !! <bg>

Pete