Ask Your Question

Can I round down in Calc? [closed]

asked 2014-07-06 23:39:28 +0100

AnonGuyy gravatar image

updated 2014-07-07 00:34:37 +0100

bencomp gravatar image

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.

Thank you for your time.

edit retag flag offensive 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

1 Answer

Sort by » oldest newest most voted

answered 2014-07-07 00:26:35 +0100

bencomp gravatar image

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.

edit flag offensive delete link 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!

AnonGuyy gravatar imageAnonGuyy ( 2014-07-07 00:29:27 +0100 )edit

You're welcome, but please do not add "//SOLVED" to the question; instead mark the answer as correct to indicate your question was answered (and let us both receive karma :)).

bencomp gravatar imagebencomp ( 2014-07-07 00:33:47 +0100 )edit

Question Tools

1 follower


Asked: 2014-07-06 23:39:28 +0100

Seen: 10,593 times

Last updated: Jul 07 '14