Rounding Numbers

J

Jay

IS there a way to round numbers to the nearest x, where x can be any
mutliple of choice. An equivalent to MROUND in Excel.

Or if I want to round to the nearest 25 will I have to use something
like this in my expressions:

Round([UnroundedNumber]/25)*25

Many thanks,

Jay
 
V

Van T. Dinh

That how you would do it BUT test your expression with 12.5, 37.5, 62.5,
87.5 ...

i.e numbers that are (X + 0.5) * 25 where X is an integer

Test also the negatives of the above if you need negative number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top