+ Reply to Thread
Results 1 to 3 of 3

rating scheme

Hybrid View

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    brisbane, Australia
    MS-Off Ver
    2010
    Posts
    7

    rating scheme

    Hi im doing a project in excel and i need to add a rating to it so that if its >50 its good if its >75 its excellent, i know how you would do this in matlab or c (just using an if loop) but no idea how to do this in excel.

    any help would be greatly appreciated

    P.S this is all on the same sheet so i dont need to interact between sheets
    Last edited by Eliitedisowned; 06-23-2015 at 10:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: rating scheme

    Using a formula like this will work.

    =IF(B3<=49,"Average",IF(B3<74, "Good",IF(B3>=75,"Excellent")))

    33 Average
    25 Average
    49 Average
    51 Good
    60 Good
    75 Excellent

    Where column A would be a name, B the score, & C the formula column.
    Last edited by BlindAlley; 06-23-2015 at 10:02 PM.

  3. #3
    Registered User
    Join Date
    06-23-2015
    Location
    brisbane, Australia
    MS-Off Ver
    2010
    Posts
    7

    Re: rating scheme

    excellent thank you

+ 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. Help on creating report grading calculation method
    By jimbosi in forum Excel General
    Replies: 1
    Last Post: 11-19-2014, 09:02 PM
  2. Replies: 10
    Last Post: 09-08-2014, 08:46 AM
  3. Color Scheme Help
    By rzacharia21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2012, 11:59 PM
  4. Excel 2007 : Salary scheme
    By Skjo in forum Excel General
    Replies: 1
    Last Post: 05-22-2011, 01:02 AM
  5. [SOLVED] Color Scheme
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 08-14-2006, 01:45 AM

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