Roundig up a number

[Zbulo]

Make’s round function only rounds a decimal the closest integer.

How to round up for example 4997 to 5000?

[ecomsilio]

Hi @Zbulo

Use math functions:

{{round(2.number / 1000) * 1000}}

Cheers,
Gijs

[Zbulo]

Thanks for the quick reply. I will do so, but hoped there would be a more convenient solution than writing inline math for each case. I should add a feature request for Google Sheets like roundup function.