Is it possible with knack to build an equation that roundsup numbers to their next multiple of 5.

Example formula in Excel: =CEILING(3.5,5)

Result: 5


it works, thanks!

Thanks Sunny,

Unfortunately your proposed formula


did not work.


Result should be 1800/23 = 78€/ton, and then this value should be dounded up to 80€.