Excel Magic Trick 456: Add Only Integer Part SUM & INT functions

[@excelisfun]

You are welcome!

[@oliverjamesspicer]

You've just made me so ridiculously happy! Thank you :)

[@Quaid44]

I brought my laptop to a party and did this trick. Let's just say I didn't leave on my own that night 😊

[@excelisfun]

I love that story!!!! Being good with Excel can do magic in many ways!!!!!

[@Berghiker]

I want it to just ADD the digits to the right of the decimal ONLY, if the interger begins with a negative sign. Is this possible?

[@horvathgabor5485]

Example?

[@Berghiker]

@@horvathgabor5485 -1.5+(-1.1)+(-1.3)+(-1.2). 0.5+0.1+0.3+0.2 = 1.1

[@aqh1763]

EXCELLENT

[@FsoOmar]

Thank you!

[@excelisfun]

You are welcome!