Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions |