formula for rating values

arniebun · Jun 11, 2020

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?

AliGW · Jun 11, 2020

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/threa...in-a-rang-do-i-use-a-string-for-this.1136877/

arniebun · Jun 11, 2020

AliGW said:
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/threa...in-a-rang-do-i-use-a-string-for-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

AliGW · Jun 11, 2020

Yes - precisely.

NormS · Jun 12, 2020

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)

formula for rating values

arniebun

New member

AliGW

Administrator

arniebun

New member

AliGW

Administrator

NormS

New member