software

Howdy~
I am using excel to complete weekly employee reviews. The employee rating
is done on a point scale. E.g., outstanding= 10, good = 8....etc

In the reveiw an employee gets a rating from the total point unless they
score needs improvment in two or a unsatisfactory in a single feild.

Is there a way to scan short list of text and give a points total unless the
above paragraph is met.

For example, the rating could have 4 fields and two employee scores
Outstanding = 10
Outstanding = 10
Outstanding = 10
Outstanding = 10
or a total of 40 points = outstanding
but a different employee could score

Outstanding = 10
Outstanding = 10
Outstanding = 10
Unsatisfactory= 4

How can I scan to find that single quot;Uquot; to give a rating of Unsatisfactory?
I cannot use points becuase this empoyees high marks in the frist three
categories would skew the numbersHi Markh,

Have you tried using countif function? You could combine this with an IF
statement to indicate where there is a problem.

This formula will give you an unsatisfactory if the employees scores less
than 7 in more than one area of competence.
=IF(COUNTIF(B1:B5,quot;lt;7quot;)gt;1,quot;unsatisfactoryquot;,quot;quot;)

Hope this helps.
Michael

quot;Markhquot; wrote:

gt; Howdy~
gt; I am using excel to complete weekly employee reviews. The employee rating
gt; is done on a point scale. E.g., outstanding= 10, good = 8....etc
gt;
gt; In the reveiw an employee gets a rating from the total point unless they
gt; score needs improvment in two or a unsatisfactory in a single feild.
gt;
gt; Is there a way to scan short list of text and give a points total unless the
gt; above paragraph is met.
gt;
gt; For example, the rating could have 4 fields and two employee scores
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; or a total of 40 points = outstanding
gt; but a different employee could score
gt;
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Unsatisfactory= 4
gt;
gt; How can I scan to find that single quot;Uquot; to give a rating of Unsatisfactory?
gt; I cannot use points becuase this empoyees high marks in the frist three
gt; categories would skew the numbers
gt;

Thanks~
is it possible to do the same/simular command testing for a feild with a
certain text in it?
thanks in advance

quot;Markhquot; wrote:

gt; Howdy~
gt; I am using excel to complete weekly employee reviews. The employee rating
gt; is done on a point scale. E.g., outstanding= 10, good = 8....etc
gt;
gt; In the reveiw an employee gets a rating from the total point unless they
gt; score needs improvment in two or a unsatisfactory in a single feild.
gt;
gt; Is there a way to scan short list of text and give a points total unless the
gt; above paragraph is met.
gt;
gt; For example, the rating could have 4 fields and two employee scores
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; or a total of 40 points = outstanding
gt; but a different employee could score
gt;
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Unsatisfactory= 4
gt;
gt; How can I scan to find that single quot;Uquot; to give a rating of Unsatisfactory?
gt; I cannot use points becuase this empoyees high marks in the frist three
gt; categories would skew the numbers
gt;

sorry for id-ten-t error on the last post. I can use the following
=IF(COUNTIF(C21:H21,quot;Uquot;)gt;1,quot;UNsatquot;,quot;quot;)
but how can I add the more selection creteria
I need to check for two quot;Uquot;'s and then for NI so i need to add the two
formula's together. adding the
=IF(COUNTIF(C21:H21,quot;NIquot;)gt;2,quot;NIquot;,quot;quot;) to intergetate the same cell.

thanksquot;Markhquot; wrote:

gt; Howdy~
gt; I am using excel to complete weekly employee reviews. The employee rating
gt; is done on a point scale. E.g., outstanding= 10, good = 8....etc
gt;
gt; In the reveiw an employee gets a rating from the total point unless they
gt; score needs improvment in two or a unsatisfactory in a single feild.
gt;
gt; Is there a way to scan short list of text and give a points total unless the
gt; above paragraph is met.
gt;
gt; For example, the rating could have 4 fields and two employee scores
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; or a total of 40 points = outstanding
gt; but a different employee could score
gt;
gt; Outstanding = 10
gt; Outstanding = 10
gt; Outstanding = 10
gt; Unsatisfactory= 4
gt;
gt; How can I scan to find that single quot;Uquot; to give a rating of Unsatisfactory?
gt; I cannot use points becuase this empoyees high marks in the frist three
gt; categories would skew the numbers
gt;

Hi Mark,

This one should do it then, just nest the IF statements:
=IF(COUNTIF(C21:H21,quot;Uquot;)gt;1,quot;UNsatquot;,IF(COUNTIF(C21: H21,quot;NIquot;)gt;1,quot;NIquot;,quot;quot;))

Michael

quot;Markhquot; wrote:

gt; sorry for id-ten-t error on the last post. I can use the following
gt; =IF(COUNTIF(C21:H21,quot;Uquot;)gt;1,quot;UNsatquot;,quot;quot;)
gt; but how can I add the more selection creteria
gt; I need to check for two quot;Uquot;'s and then for NI so i need to add the two
gt; formula's together. adding the
gt; =IF(COUNTIF(C21:H21,quot;NIquot;)gt;2,quot;NIquot;,quot;quot;) to intergetate the same cell.
gt;
gt; thanks
gt;
gt;
gt; quot;Markhquot; wrote:
gt;
gt; gt; Howdy~
gt; gt; I am using excel to complete weekly employee reviews. The employee rating
gt; gt; is done on a point scale. E.g., outstanding= 10, good = 8....etc
gt; gt;
gt; gt; In the reveiw an employee gets a rating from the total point unless they
gt; gt; score needs improvment in two or a unsatisfactory in a single feild.
gt; gt;
gt; gt; Is there a way to scan short list of text and give a points total unless the
gt; gt; above paragraph is met.
gt; gt;
gt; gt; For example, the rating could have 4 fields and two employee scores
gt; gt; Outstanding = 10
gt; gt; Outstanding = 10
gt; gt; Outstanding = 10
gt; gt; Outstanding = 10
gt; gt; or a total of 40 points = outstanding
gt; gt; but a different employee could score
gt; gt;
gt; gt; Outstanding = 10
gt; gt; Outstanding = 10
gt; gt; Outstanding = 10
gt; gt; Unsatisfactory= 4
gt; gt;
gt; gt; How can I scan to find that single quot;Uquot; to give a rating of Unsatisfactory?
gt; gt; I cannot use points becuase this empoyees high marks in the frist three
gt; gt; categories would skew the numbers
gt; gt;