May 07 2022 01:05 PM
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 rounddown within the same cell that has this formula.
fx=Sum(A2+A3)
thanks for solution.
May 07 2022 01:58 PM
SolutionThat 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.
May 07 2022 02:05 PM
As a learning opportunity, the answer that @Hans Vogelaar has given you is an example of what's called "nesting"--it is possible to "nest" one function inside another, and in fact it is possible to do so (though not always advisable) to nest functions many levels deep. The reason why it's not always advisable: it can become difficult to understand them or maintain them.
But it's a good thing to know about. Here's a good website to start that learning.
May 07 2022 03:58 PM
awesome and thank you.
Was on the internet searching and many references are just on rounding on a different cell.
Now I’m introduced to Nesting, I will explore further as challenges built up over time.
:thumbs_up:
May 07 2022 01:58 PM
SolutionThat 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.