I really need help with a rule

  • Thread starter Thread starter TORIA28
  • Start date Start date
T

TORIA28

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
 
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 said:
=IF(MODE([range]))=3"HiPo",.................

should give you what you want


TORIA28 said:
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
Click to expand...
Click to expand...
 
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

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 said:
=IF(MODE([range]))=3"HiPo",.................
Click to expand...
should give you what you want
Click to expand...

- Show quoted text -
Click to expand...
 
TORIA28 said:
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)
Click to expand...

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

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


----- original posting -----
 
Back
Top