Need help rounding down results of a formula

[mmartin6262]

I need help adding round down to an existing formula. Any one out there know how to add?

I want to perform the following calculation & round down the results in the same cell. For example. . . my formula in B15 is =D13*F13/1095. Right now the result showing in B15 is 58.35342466. I want the formula to also round the result of this formula down to the nearest whole number & still return the results to B15 (despite the number of digits of the whole number - this example is two but it could be three or four digits.

Any help figuring this out will be most appreciated! Thanks!

 

[63falcondude]

I may be misunderstanding what you are looking for here. If you want to keep the exact value but round the displayed number, simply click the Decrease Decimal button in the "Number" group of the Home tab.

 

[Joe4]

Welcome to the Board!

You should be able use either the ROUNDDOWN or INT functions to do this.
See:
https://www.techonthenet.com/excel/formulas/rounddown.php
https://www.techonthenet.com/excel/formulas/int.php

 

[Aladin Akyurek]

Maybe:

=ROUND(D13*F13/1095,0)

 

[Joe4]

Maybe:

=ROUND(D13*F13/1095,0)

But that does not always round down. If you want to round down, you would want:
=ROUNDDOWN(D13*F13/1095,0)
or
=INT(D13*F13/1095)

*Note: If you may have negative numbers, INT and ROUNDDOWN may give different results, i.e.
=ROUNDDOWN(-20/3,0)=-6
=INT(-20/3)=-7

 

[Aladin Akyurek]

Try TRUNC instead of INT...

 

[Joe4]

Try TRUNC instead of INT...

I am thinking it really depends on the requirements. Negative numbers can get a little tricky.
=TRUNC(-20/3) = -6

Typically, when you think of rounding down, mathematically speaking, it is rounding to the the nearest whole number that is less than or equal to the returned value. In dealing with negative numbers, that would be -7 in my example. INT would do that.

However, TRUNC and ROUNDDOWN don't quite to that. They actually round to the closest whole number moving in the direction towards 0 (and returns -6 in my example). In some cases, that might be what the user is after.

So I think which one to use depends on user requirements. Of course, it is all academic if they are not dealing with negative numbers. Then any of the three options should work.

 

[63falcondude]

Whoops... missed the round down part.