I have values in cells f5 and h5.These values range from 1.01 to
1000,but are in bands, and there only allowed increments in each band.

Min max increment
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 n5 I want create a condition that will carry out an action if
1.the difference between the values in h5 and f5 is greater than two or
more increments and 2.f5 has
A value less than 10. This action is to place in cell o5 a formula that
puts in this cell
A value 1 increment less than the current value in h5.

To try and make myself clearer,say the values in f5 and h5 are 4.2 and
17 respectively.

F5 is less than 10.There is a difference of more than or equal to 2
increments.
The two conditions are fulfilled thus I place 16.5( one increment less
than 17) in cell o5.


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