Mround in Easymorph

1

Hi, am looking for a function that can do the same as Mround in Excel.

For example;
MROUND(8,20;0,25)

Answer 8,25

So rounding to the closest multiple of 0,25.

Does anybody have a suggestion?

2

I would use:

round([Value] / [Grain], 0) * [Grain]

In this case

round(8.25 / 0.25, 0) * 0.25 = 8.25

See example below:

mround.morph (1.4 KB)

3

ah great, thanks Dmitry! And thanks for responding so quickly.

4

You’re welcome!