Results 1 to 6 of 6

Pay Grade Population Formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    Pay Grade Population Formula

    Hi Everyone,

    Could you let me know how to rework this formula to better serve me ...

    I am currently using this:
    =LOOKUP(COUNTIF(J5:FU5,"Completed"),{0,19,48,71,85,95,101,111,130,150,168},{"Starting Grade (£6.31)","Grade 1 (£6.45)","Grade 2 (£6.55)","Grade 3 (£6.75)","Grade 4.1 (£6.95)","Grade 4.2 (£7.25)","Grade 4.3 (£7.45)","Grade 4.4 (£7.55)","Grade 5 (£7.95)","Grade 6 (£8.45)","Grade 7 (£8.95)"})

    So if 0-18 occurrences of "Completed" are found within the range then "Starting Grade (£6.31)" is displayed in the cell. If 19-47 occurrences are found then "Grade 1 (£6.45)" is displayed and so on.

    I want to update this and change the "Completed" to a choice of multiple words (i.e. January, February, March, April ... December) so if any of these words are found they count as 1 value. So any month would count the same as one "Completed" in the old formula.

    You will see at the far right of the screen I have placed my various pay grades that I want to show at each of the increments (i.e. 0-18, 19-47, 48-70, 71-84, 85-94, 95-100, 101-110, 111-129, 130-149, 150-168).

    Is this possible?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-30-2013, 01:28 PM
  2. Replies: 5
    Last Post: 02-17-2013, 03:29 PM
  3. Conditional formatting to reflect exam grade compared to predicted grade
    By strangecharm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-20-2012, 09:33 AM
  4. Student grade inputting and grade percentage calculations
    By confusedteacher in forum Excel General
    Replies: 2
    Last Post: 10-23-2011, 07:50 PM
  5. Macro To Change Letter Grade To Number Grade
    By florinel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2008, 11:14 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