=ceiling(3.5,5)

Help Center Get Answers
1

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

 

2

it works, thanks!

3

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€.