I have to create a formula in say cell B25 to calculate a value called say
'multiplier' based on ratio (or percentage) of attainment with respect to
goals. I have a cell say B23 which contains the value of this percentage in
one cell of my worksheet and based on this value, I have to find a
multiplier. I have the following table for finding the multiplier. eg. if the
ratio (or percentage was 115% (value in B23) then this formula should be able
to look up the multiplier in the follwing table; based on this table, it
would fall in the 3rd row range and should result 1.1

From To Multiplier
0% 49% 0
50% 109% 1
110% 119% 1.1
120% 129% 1.2
130% 139% 1.3
140% 149% 1.4
150% 169% 1.5
170% 199% 1.6
200% 239% 1.7
240% + 2
How can I do this