Results 1 to 4 of 4

Thread: If Formula to calculate a score

  1. #1

    If Formula to calculate a score



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello

    Please could I get some assistance on a formula to calculate the below scores. The if formulas that I have been trying to use are not working.

    If i have these % weightings how do i use an if formula to get the below scores?

    Target Score
    <90% 0
    >=90% 1
    >=95% 2
    >=100% 3
    >=110% 4
    >=120% 5

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Try this:

    Code:
    =LOOKUP(A2,{0,0.9,0.95,1,1.1,1.2},{0,1,2,3,4,5})

  3. #3
    Thank you so much. this works wonderfully!!!

  4. #4
    You could also use a combination of ifs if you would like to. Thought the above solution seems better.

Posting Permissions

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