# Can I round down in Calc? [closed]

Just like the ROUNDUP feature, it'd be nice to have a ROUNDDOWN or ROUNDDN feature to always round down no matter what. Using this function would always output the base integer whether you have 52.00001 or 52.9, you'd get 52 for both.

Ex: 6/4 = 1.5, but =ROUNDDN(6/4) would output 1.

Here's a direct example of what I'm trying to do. I want to round down so I don't go over and instead the amount one below is automatically chosen. I do this for Fletching logs into arrow shafts in Runescape to make gp. :)

Money to Spend:
[I3] Pouch: 1,218,070 gp
[I4] Price of Logs: 336 gp
[I5] GP to use: 218,070 gp
[I6] Amount of Logs: 649.0178571429 {=I5/I4}
[I7] Pouch After: 1,000,000 gp {=I3-(I6*I4)}


I'd like the value on I6 to be 649 instead of all those other decimals to make it easier (remove all errors) with all the other calculations further down the chart. So in this case I would put "=ROUNDDN(I5/I4) in I5 rather than what's there.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-28 20:39:16.200083

Sort by » oldest newest most voted

There already is a function ROUNDDOWN( number; count) that takes the number to round and the number of decimals to keep after the decimal separator.

In your example, you would want the count to be 0.

more

Wow, I'm an idiot. .-. I swear I've tried this before many times and it just gave me errors.

Anywho, thank you very much!

( 2014-07-07 00:29:27 +0200 )edit