Example in Finmark using "Round" Formula Function:

Round

Round(expr)

round a given expr to nearest integer.

Round(expr, factor)

round a given expr up to the next nearest multiple of a factor.

See

Examples

>> Round(-3.6) -4 >> Round(1.234512, 0.01) 1.23 >> Round(1.235512, 0.01) 1.24

Round to nearest multiple of 5

>> Round({12.5, 62.1, 68.3, 74.5, 80.7}, 5) {10,60,70,75,80}
Did this answer your question?