View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dennis dennis is offline
external usenet poster
 
Posts: 202
Default 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