ExcelBanter - Formula Entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula Entry (https://www.excelbanter.com/excel-worksheet-functions/204643-formula-entry.html)

Susi

Formula Entry

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

WLMPilot

Formula Entry

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

Susi

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

All times are GMT +1. The time now is 07:26 AM.