I don't really understand what the significance of a "condition in N5"
means,
BUT ... Try this out.

Create a datalist, in say Y1 to Z19
Y Z
1 0.01
2 0.01
2.01 0.02
3 0.02
3.01 0.05
4 0.05
4.01 0.1
6 0.1
6.01 0.2
10 0.2
10.01 0.5
20 0.5
20.01 1
30 1
30.01 2
50 2
50.01 5
100 5
100.01 10

Then, enter this formula in O5:

=IF(AND(F5<10,H5-F5=(LOOKUP(H5,Y1:Z19))*2),H5-LOOKUP(H5,Y1:Z19),"")

If criteria is not met, O5 will remain blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pytelium" wrote in
message ...

The larger number will have always be in h5 except in the case where h5
is blank


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