Forum Discussion
Jarebb
May 07, 2022Copper Contributor
Rounddown function within the same cell after a function
I would like to ROUNDDOWN the result after the Function within the same cell. A2=1.2 A3= 1.6 A4= formula to sum cell A2 and A3 and thereafter Rounddown. example: how do I include the ro...
HansVogelaar
May 07, 2022MVP
That would be
=ROUNDDOWN(SUM(A2+A3),0)
if you want to round down to a whole number (0 decimal places)
Note that SUM isn't really needed: =SUM(A2+A3) is equivalent to =A2+A3.
Or you could use =SUM(A2:A3). That is actually preferable since it ignores text values.