Hi, welcome to the forum
I would set this up in a small table (below), then use a VLOOKUP...
A B C D 2 16 0.25 60 3 38 0.50 1 4 53 0.75 5 60 1.00 6 76 1.25 7 98 1.50 8 113 1.75 9 120 2.00
D2= your value
D3=VLOOKUP(D2,$A$2:$B$9,2,1)
When you add your extra variables, just increace the range (bolded)
Bookmarks