Hi Devorse,

Rounding quite different than FLOOR.MATH/CEILING.MATH, especially when you start to consider the significance and mode properties of the Excel functions.  To round a value to a specific number of digits, you can simply multiply it by 10^n (where n is the number of digits), add/subtract 0.5, take the INTE() value and then divide by 10^n:

! val = input value

! n = number of digits

! res = result value

IF val > 0 

    res = INTE(val * POWR(10, n) + 0.5 * SIGN(val)) / POWR(10, n)

ELSE 

    res = INTE(val * POWR(10, n) - 0.5 * SIGN(val)) / POWR(10, n)

ENDIF

For the value of 24.432, this will never be rounded up to 24.5 though because the 100’s place is not greater than 5.  However, if you use 24.452, then you can get 24.0 if n = 0 and 24.5 if n = 1.  This gives the same values as the ROUND function.

Unless you have a very specific need, I’m not sure you need to implement the exact FLOOR.MATH/CEILING.MATH algorithms, especially seeing how these can often be unintuitive.  For example, FLOOR.MATH(-10, 4) gives -12 and FLOOR.MATH(-7.35, 0.2) gives -7.4.  If you need these exact algorithms, you will need to create a SUB routine which will calculate the modulus of the number and the significance and then calculate the exact value.

~Michael