I really need help with a rule
 

I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8
________________
John 3 3 2 3 2 2 3 3
Mark 1 1 1 1 1 1 1 1
Mary 2 2 2 2 3 2 3 2
Sara 0 0 0 0 0 0 0 0
Kate 3 3 2 2 2 3 2 3

At the end of each row I would like a formula that calculates the following:

*If someone got mainly 3's then the cell should say "HiPo" (High Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this

I really need help with a rule
 

=IF(MODE([range]))=3"HiPo",.................

should give you what you want


"TORIA28" wrote in message
...
I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8
________________
John 3 3 2 3 2 2 3 3
Mark 1 1 1 1 1 1 1 1
Mary 2 2 2 2 3 2 3 2
Sara 0 0 0 0 0 0 0 0
Kate 3 3 2 2 2 3 2 3

At the end of each row I would like a formula that calculates the
following:

*If someone got mainly 3's then the cell should say "HiPo" (High
Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this

I really need help with a rule
 

Hi Graham, thankyou for the help but it doesn't seem to be working. Also how
do I add to the rule so that if the mode is 2 is is "HiVA" etc, many thanks

Toria

"Graham Whitehead" wrote:

=IF(MODE([range]))=3"HiPo",.................

should give you what you want


"TORIA28" wrote in message
...
I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8
________________
John 3 3 2 3 2 2 3 3
Mark 1 1 1 1 1 1 1 1
Mary 2 2 2 2 3 2 3 2
Sara 0 0 0 0 0 0 0 0
Kate 3 3 2 2 2 3 2 3

At the end of each row I would like a formula that calculates the
following:

*If someone got mainly 3's then the cell should say "HiPo" (High
Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this

I really need help with a rule
 

Try this:

=IF(MODE([range])=3,"HiPo",IF(MODE([range])=2,"HiVa",IF(MODE([range])
=1,"DR",IF(MODE([range])=0,"NiR",""))))

where [range] might be B3:I3 for John.

Copy down as required.

Hope this helps.

Pete

On Mar 9, 11:00*am, TORIA28 wrote:
Hi Graham, thankyou for the help but it doesn't seem to be working. Also how
do I add to the rule so that if the mode is 2 is is "HiVA" etc, many thanks

Toria



"Graham Whitehead" wrote:
=IF(MODE([range]))=3"HiPo",.................

should give you what you want

"TORIA28" wrote in message
...
I have a set of scoring results for individuals for 8 different areas eg:
* * * * * * * *1 *2 *3 *4 *5 *6 *7 *8
* * * * * * * *________________
John * * * * 3 *3 *2 *3 *2 *2 *3 *3
Mark * * * * 1 *1 *1 *1 *1 *1 *1 *1
Mary * * * * 2 *2 *2 *2 *3 *2 *3 *2
Sara * * * * 0 *0 *0 *0 *0 *0 *0 *0
Kate * * * * 3 *3 *2 *2 *2 *3 *2 *3

At the end of each row I would like a formula that calculates the
following:

*If someone got mainly 3's then the cell should say "HiPo" (High
Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this- Hide quoted text -

- Show quoted text -

I really need help with a rule
 

"TORIA28" wrote:
At the end of each row I would like a formula that calculates the following:
*If someone got mainly 3's then the cell should say "HiPo" (High Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)

Suppose the scores for John are in B3:I3. Then:

=choose(1+mode(B3:I3),"NR","CR","HiVa","HiPo")


----- original posting -----

"TORIA28" wrote:
I have a set of scoring results for individuals for 8 different areas eg:
1 2 3 4 5 6 7 8
________________
John 3 3 2 3 2 2 3 3
Mark 1 1 1 1 1 1 1 1
Mary 2 2 2 2 3 2 3 2
Sara 0 0 0 0 0 0 0 0
Kate 3 3 2 2 2 3 2 3

At the end of each row I would like a formula that calculates the following:

*If someone got mainly 3's then the cell should say "HiPo" (High Potential)
*If someone got mainly 2's then the cell should say "HiVa" (High Value)
*If someone got mainly 1's then the cell should say "DR" (DEvelopment
Required)
*If someone got mainly 0's then the cell sould say "NiR" (New in Role)
Thankyou for your help on this