Forum Discussion
Rounddown function within the same cell after a function
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.
As a learning opportunity, the answer that HansVogelaar 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.
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.👍
