ASSESSMENT FORMULA
 

Hello

I am trying to do an assessment for the employee
based on the assessment total we r taking into consideration the
raise
What i need is to display those text whenever this number is shown in
the total average

A1=(1-1.7) B1=UNSATISFACTORY
A2=(1.8-2.5) B2= NEEDS IMPROVEMENT
A3= (2.6-3.4) B3= MEETS EXPECTATION

A10= TOTAL AVERAGE EXAMPLE : 2.5
I NEED A FORMULA THAT WRITES FOR ME = NEEDS IMPROVEMENT


THANK YOU IN ADVANCE

ASSESSMENT FORMULA
 

set your spreadsheet up as follows:

a1 = 0
a2 = 1.7
a3 = 1.8
a4 = 2.5


b1 = Unsatisfactory
b2 = Unsatisfactory
b3 = Needs Improv...
b4 = Meets Exp...


assuming your average is in cell A10... =VLOOKUP(A10,$A$1:$B$4,2,1)
this will return the value you're looking for.

On Jun 12, 8:51 am, Tia wrote:
Hello

I am trying to do an assessment for the employee
based on the assessment total we r taking into consideration the
raise
What i need is to display those text whenever this number is shown in
the total average

A1=(1-1.7) B1=UNSATISFACTORY
A2=(1.8-2.5) B2= NEEDS IMPROVEMENT
A3= (2.6-3.4) B3= MEETS EXPECTATION

A10= TOTAL AVERAGE EXAMPLE : 2.5
I NEED A FORMULA THAT WRITES FOR ME = NEEDS IMPROVEMENT

THANK YOU IN ADVANCE

ASSESSMENT FORMULA
 

=IF(A10<=1.7,"UNSATISFACTORY",IF(A10<=2.5,"NEEDS IMPROVEMENT","MEETS
EXPECTATION"))

"Tia" wrote:

Hello

I am trying to do an assessment for the employee
based on the assessment total we r taking into consideration the
raise
What i need is to display those text whenever this number is shown in
the total average

A1=(1-1.7) B1=UNSATISFACTORY
A2=(1.8-2.5) B2= NEEDS IMPROVEMENT
A3= (2.6-3.4) B3= MEETS EXPECTATION

A10= TOTAL AVERAGE EXAMPLE : 2.5
I NEED A FORMULA THAT WRITES FOR ME = NEEDS IMPROVEMENT


THANK YOU IN ADVANCE