SOLVED

Rounddown function within the same cell after a function

%3CLINGO-SUB%20id%3D%22lingo-sub-3338094%22%20slang%3D%22en-US%22%3ERounddown%20function%20within%20the%20same%20cell%20after%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3338094%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20ROUNDDOWN%20the%20result%20after%20the%20Function%20within%20the%20same%20cell.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EA2%3D1.2%3C%2FP%3E%3CP%3EA3%3D%201.6%3C%2FP%3E%3CP%3EA4%3D%20formula%20to%20sum%20cell%20A2%20and%20A3%20and%20thereafter%20Rounddown.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Eexample%3A%20how%20do%20I%20include%20the%20rounddown%20within%20the%20same%20cell%20that%20has%20this%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3Efx%3DSum(A2%2BA3)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20solution.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3338094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3338439%22%20slang%3D%22en-US%22%3ERe%3A%20Rounddown%20function%20within%20the%20same%20cell%20after%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3338439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1383887%22%20target%3D%22_blank%22%3E%40Jarebb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20would%20be%3C%2FP%3E%0A%3CP%3E%3DROUNDDOWN(SUM(A2%2BA3)%2C0)%3C%2FP%3E%0A%3CP%3Eif%20you%20want%20to%20round%20down%20to%20a%20whole%20number%20(0%20decimal%20places)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENote%20that%20SUM%20isn't%20really%20needed%3A%20%3DSUM(A2%2BA3)%20is%20equivalent%20to%20%3DA2%2BA3.%3C%2FP%3E%0A%3CP%3EOr%20you%20could%20use%20%3DSUM(A2%3AA3).%20That%20is%20actually%20preferable%20since%20it%20ignores%20text%20values.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3338565%22%20slang%3D%22en-US%22%3ERe%3A%20Rounddown%20function%20within%20the%20same%20cell%20after%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3338565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1383887%22%20target%3D%22_blank%22%3E%40Jarebb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20learning%20opportunity%2C%20the%20answer%20that%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bhas%20given%20you%20is%20an%20example%20of%20what's%20called%20%22nesting%22--it%20is%20possible%20to%20%22nest%22%20one%20function%20inside%20another%2C%20and%20in%20fact%20it%20is%20possible%20to%20do%20so%20(though%20not%20always%20advisable)%20to%20nest%20functions%20many%20levels%20deep.%20The%20reason%20why%20it's%20not%20always%20advisable%3A%20it%20can%20become%20difficult%20to%20understand%20them%20or%20maintain%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it's%20a%20good%20thing%20to%20know%20about.%20Here's%20a%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fglossary%2Fnesting%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Egood%20website%3C%2FA%3E%20to%20start%20that%20learning.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3338949%22%20slang%3D%22en-US%22%3ERe%3A%20Rounddown%20function%20within%20the%20same%20cell%20after%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3338949%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eawesome%20and%20thank%20you.%26nbsp%3B%3CBR%20%2F%3EWas%20on%20the%20internet%20searching%20and%20many%20references%20are%20just%20on%20rounding%20on%20a%20different%20cell.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20I%E2%80%99m%20introduced%20to%26nbsp%3B%3CSTRONG%3ENesting%2C%26nbsp%3B%3C%2FSTRONG%3EI%20will%20explore%20further%20as%20challenges%20built%20up%20over%20time.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3Athumbs_up%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

3 Replies
best response confirmed by Jarebb (New Contributor)
Solution

@Jarebb 

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.

@Jarebb 

 

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.

 

 

@Hans Vogelaar 

@mathetes 

 

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.