Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible questions on assessment test | Excel Discussion (Misc queries) | |||
Assessment Worksheet | Excel Discussion (Misc queries) | |||
employee assessment test | Excel Discussion (Misc queries) | |||
Point Assessment Calc? | Excel Discussion (Misc queries) | |||
Capacity Assessment | Excel Discussion (Misc queries) |