I believe this will work for you.

=IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8),""))

Les

"Susi" wrote:

How can I get this formula to return a Rounded Down to an Whole Number?


=IF(($I14-$A14)<0,IMABS($I14-$A14)*0.8,"")

Thanks