Rounding up to the nearest 10

How do I?
1

Hi, is it possible to round to a specific interval? For example I’d like to round up a sum to the nearest 10?

As a better example, I track my “bills” and would like to sum all of those, round up to the nearest £10, and then add an additional £20 as a buffer; I do this in excel using CEILING

2

Hey Jack,
Causal actually does have a function to round to a specific interval. Whether you are using round(), rounddown(), or roundup(). These functions take two inputs, the number itself along with the digit that you are intending to round.

In regards to the digit parameter, no value or a value of 0 would round to the nearest whole number, while -1 would round to the nearest tens digit and 1 would round to the nearest tenths digit.

An example in your case might be rounding the value of ‘£153’ and you are looking to round up to the nearest tens digit, so you would use 'roundup(153, -1).

2 Likes