R
readystate
I have a series of FROM/TO ratings in a table (see below). I want to build a
formula for my spreadsheet that will automatically capture the ADJ Rating
whenever the number falls within the From/To Range. Any suggestions? Thanks
in advance.
Range (from / to) Adj Rating
0.01 0.95 As Is
0.96 0.99 1.00
1.00 1.03 1.05
1.04 1.05 1.10
1.06 1.09 1.15
1.10 1.15 1.20
1.16 1.20 1.25
1.21 1.25 1.50
1.26 3.00 2.00
formula for my spreadsheet that will automatically capture the ADJ Rating
whenever the number falls within the From/To Range. Any suggestions? Thanks
in advance.
Range (from / to) Adj Rating
0.01 0.95 As Is
0.96 0.99 1.00
1.00 1.03 1.05
1.04 1.05 1.10
1.06 1.09 1.15
1.10 1.15 1.20
1.16 1.20 1.25
1.21 1.25 1.50
1.26 3.00 2.00