Can I round down in Calc?

[AnonGuyy]

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.

[bencomp]

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.

[AnonGuyy]

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!

[bencomp]

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 :)).