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
|