Formula Problems
"Ron Rosenfeld" wrote in message
...
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
Hi Ron,
=IF(ISERROR(ROUND(7/(C3-D3),5)*C3*D3),"",
IF((ROUND(7/(C3-D3),5)0.5),ROUND(7/(C3-D3),5),""))
definitely I was unable to miss 2nd IF clause.
Ciao
Bruno
|