Results 1 to 5 of 5

Thread: formula for rating values

  1. #1
    Neophyte arniebun's Avatar
    Join Date
    Jun 2020
    Posts
    2
    Articles
    0
    Excel Version
    2019

    formula for rating values



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

    Click image for larger version. 

Name:	Untitled.jpg 
Views:	20 
Size:	86.3 KB 
ID:	9851
    what I want to do as the image above, is rate the values if they are between the values on the right of the table by the values on the left. so if the far right column are lets say 3.77 in will take the rating value of the (display these numbers) so it will return a value of 9 in the Column which says (display numbers go here). Do I need to use java script for this, or can it be done in a long string?

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,445
    Articles
    0
    Excel Version
    Office 365 Subscription
    On this and most other forums, you are required to tell us if you have asked the same question on another forum. As you are new, I will do it for you this time.

    https://www.mrexcel.com/board/thread...-this.1136877/
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte arniebun's Avatar
    Join Date
    Jun 2020
    Posts
    2
    Articles
    0
    Excel Version
    2019
    Quote Originally Posted by AliGW View Post
    On this and most other forums, you are required to tell us if you have asked the same question on another forum. As you are new, I will do it for you this time.

    https://www.mrexcel.com/board/thread...-this.1136877/
    hi do i have to do this on their to link to here, sorry first time i have ever asked for help on a form

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,445
    Articles
    0
    Excel Version
    Office 365 Subscription
    Yes - precisely.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Conjurer NormS's Avatar
    Join Date
    Jul 2017
    Posts
    122
    Articles
    0
    Excel Version
    Excel 2016 ProPlus
    If this hasn't been answered on the other forum you can use VLOOKUP. However, you need to sort the table on the right in ascending order from -2.5 to 5.5. Assuming that table is in E5:F21

    Code:
    =VLOOKUP(100*A3,$E$5:$F$21,2,TRUE)

Posting Permissions

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