Trying to find a formula that can help me give a value to different range of numbers.
The numbers will range between 600 to -600 and will change constantly.
400 to 600 =10
250 to 399=7.5
100 to 249 =5
99 to -99 =0
-100 to -249 = -5
-200 to -399 = -7.5
-400 to -600 = -10
so if a1=140 b2=5
if a1=-415 b2=-10
if a1=50 b2 =0
Thanks in advance
Bookmarks