P
pytelium
have values in cells f5 and h5.These values range from 1 to 1000,but ar
in bands, and there only allowed increments in each band.
Min max incr
1.00 2.00 0.01
2.02 3.00 0.02
3.05 4.00 0.05
4.10 6.00 0.10
6.20 10.00 0.20
10.50 20.00 0.50
21.00 30.00 1.00
32.00 50.00 2.00
55.00 100.00 5.00
110.00 1000.00 10.00
Thus allowed values are 1.01,1.02,-----,2.02,2.04-----,3.05,3.10,3.1
etc.
In cell c25 I have difference between f5 and h5.I need to put in cel
d25,the number of increments between f5 and h5.
Suppose f5 is 5.7 and h5 is 17. How many increments is this?
By hand,5.7 to 6 is 3 increments,6 to 10 is 20 increments and 10 to 1
is 14 increments, a total of 37 increments
in bands, and there only allowed increments in each band.
Min max incr
1.00 2.00 0.01
2.02 3.00 0.02
3.05 4.00 0.05
4.10 6.00 0.10
6.20 10.00 0.20
10.50 20.00 0.50
21.00 30.00 1.00
32.00 50.00 2.00
55.00 100.00 5.00
110.00 1000.00 10.00
Thus allowed values are 1.01,1.02,-----,2.02,2.04-----,3.05,3.10,3.1
etc.
In cell c25 I have difference between f5 and h5.I need to put in cel
d25,the number of increments between f5 and h5.
Suppose f5 is 5.7 and h5 is 17. How many increments is this?
By hand,5.7 to 6 is 3 increments,6 to 10 is 20 increments and 10 to 1
is 14 increments, a total of 37 increments