variable gaps
 

have values in cells f5 and h5.These values range from 1 to 1000,but are
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.15
etc.


In cell c25 I have difference between f5 and h5.I need to put in cell
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 17
is 14 increments, a total of 37 increments.


--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=476957

variable gaps
 

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)
--
Earl Kiosterud
www.smokeylake.com

"pytelium" wrote in
message ...

have values in cells f5 and h5.These values range from 1 to 1000,but are
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.15
etc.


In cell c25 I have difference between f5 and h5.I need to put in cell
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 17
is 14 increments, a total of 37 increments.


--
pytelium
------------------------------------------------------------------------
pytelium's Profile:
http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=476957