Results 1 to 9 of 9

Which formula to use to calculate ratings

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    42

    Which formula to use to calculate ratings

    Good day,

    I'm looking for a formula to use. I need to calculate ratings on variances in percentages:

    Variance vs expected Rating
    0% 3
    1-5% 2.5
    6-10% 2
    10-15% 1.5
    15%+ 1

    The expected percentage is 5. In other words if a % below 5 is obtained the rating is 3. Between 6% and 10% the rating should be 2.5.

    Thanks

    Lucille
    Last edited by Lucille Boshoff; 02-06-2014 at 09:01 AM. Reason: Wrong title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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