#1   Report Post  
Junior Member
 
Posts: 2
Default Employee Appraisal

I want to calculate the average in an employee survey/appraisal. I have 40 criteria (rows) where you could check mark one of five columns titled 1,2,3,4, and 5, respectively. How can I determine if the employee has, for example, an average of 3.0 or else? I know that I could just use a single column where he evaluator could type a number from 1 to 5, and then I could determine the weighted average. However, I do not want to use this last approach. Thank you for your help. Oscar

Last edited by Oscar Leon : December 21st 10 at 06:20 PM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Function? Employee Number with Employee Name Lance Hebert[_2_] Excel Worksheet Functions 1 March 9th 10 05:25 PM
employee Ronnie Excel Discussion (Misc queries) 1 February 12th 08 10:38 AM
Searching for a Appraisal form for Gems stomes and pearls Min Excel Worksheet Functions 0 November 23rd 07 12:12 PM
Calculate employee hours for employee evaluation? Triesha Excel Worksheet Functions 3 February 9th 06 02:52 PM
Fromula to take employee # out of employee name field mikeburg Excel Discussion (Misc queries) 9 September 12th 05 03:41 AM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"