+ Reply to Thread
Results 1 to 2 of 2

Excel Formula for grading employee

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel Formula for grading employee

    Hi!

    I just want to know the formula for our stats for our employee to grade their performance.
    Let us say that the criteria for passing the sales rate is 25% and 75% other criteria will be attendance, research, attitude etc.
    Now we need to focus on getting the formula for the sales rate. By having 10% of the meeting being converted to sales, you can get the 25% on your stats.
    Letís say that, our employee was able to set up 20 meetings and the sales were 4 out of the 20 meetings. The rule is to get 10% of your meeting so this person passed and will get the 25%
    Another employee got 20 meetings and the sale was only 1 out of 20. So that should be 5%. he failed and will only get 12.5% since that he only got half of 10% sales rate.

    What kind of formula should we use?
    Please help me, this should be very helpful for me.

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,827

    Re: Excel Formula for grading employee

    Hi,

    You can do this by nested if condition, it will be better if you provide a sample workbook showing results manually typed

    Punnam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Grading Formula
    By Nomnol2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 03:37 PM
  2. [SOLVED] Excel formula to compare pay rates based on employee ID
    By Kimston in forum Excel General
    Replies: 2
    Last Post: 07-19-2012, 04:12 AM
  3. How to Create Grading Formula
    By madmax2011 in forum Excel General
    Replies: 2
    Last Post: 07-17-2011, 02:14 AM
  4. Formula for grading workbook.
    By Spyrogyra in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2008, 08:51 AM
  5. Grading formula
    By dennisc in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 10-24-2007, 11:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1