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 |
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 |