Hi,
I need to create a method of inputting 2 values (Min and Max) then using those values to lookup from a predetermined range of values to give me the desired output value possibly rounded (up or down dependant on the number) from the range.
eg. Input value (Min) A=0.22
Input value (Max) B=0.86
Desired output value A=0.20 (Rounded Down)
Desired output value B=0.88 (Rounded Up)
The lookup range starts at 0.04 and increments up by 0.04, hence why the Output value A needs to be rounded down to the nearest 0.04 (this case 0.20) and Output value B is rounded up (to nearest 0.4 divisable) to 0.88.
If the input values are divisible by lookup value then the output value would be the same as the input value.
Just to complicate things further, the lookup range starts at 0.04 incrementing by this value up to 2.52.
From 2.52 to 12.76 the increment is 0.16.
And from 12.76 to 53.72 the increment is 0.64
And from 53.72 to 199.64 the increment is 2.56.
Many thanks to all for any assistance.
Bookmarks