On Mon, 21 Nov 2005 16:23:01 +0100, "Bruno Campanini"
wrote:

"Ron Rosenfeld" wrote in message
.. .

[...]
=IF(AND(ISNUMBER(C3),ISNUMBER(D3),C3-D3<0),IF(ROUND(7/(C3-D3),5)0.5,ROUND(7/(C3-D3),5),""),"")

or, slightly shorter:

=IF(AND(ISNUMBER(C3),ISNUMBER(D3),C3<D3),IF(ROUND (7/(C3-D3),5)0.5,ROUND(7/(C3-D3),5),""),"")

Or, a couple of byte shorter:

=IF(NOT(ISERROR(R3*S3))*(R3<S3)*(NOT(ISERROR(ROU ND(7/(R3-S3),5)))),ROUND(7/(R3-S3),5),"")

Bruno


Actually, as is, your formula has more functions than mine.

In addition, it will return values less than or equal to 0.5, so you need
another IF statement.


--ron