Formula Entry
Thank you, I just had to add the zero at the end to round it down to 0
places and it worked!
Susi
=IF(($I14-$A14)<0,ROUNDDOWN(IMABS($I14-$A14)*0.8,0),"")
"WLMPilot" wrote:
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
|