View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default 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