variable gaps

[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

 

[Earl Kiosterud]

pytelium,

I can't square your description with the table you give, nor do I quite
understand the relationship between the table, and C25 and D25. It would
help if you get this down to a particular question, like "If F5 and H5
contain a low and high number, and H5 contains an increment, what formula
will give me the count of increments between F5 and H5?"

In the case I give, you'd just divide:
=(H5-F5) / G5

If you didn't want a partial increment to be included:
=INT((H5-F5) / G5)