Hi,

In G4 i have the results of a formula which can be less than one.
In H4 there are whole numbers or a 0.

If the sum of G4-H4 is less than 1 then nothing.
If the sum of G4-H4 is 1 or more then the sum of G4-H4.

'=IF(SUM(G4-H4<=1),"",SUM(G4-H4))

If G4 has less than 1 or a fraction of 1 then i get the dreaded #VALUE!
thingy.

This seems to work UNLESS one of the cells feeding the formula in G4 is
empty
then i also the #VALUE! thingy.
=IF(H4="","",IF(H4<G4,G4-H4,0))

Any direction?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=519617