ASSESSMENT FORMULA

[Tia]

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

 

[Tim879]

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.

 

[Dennis]

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