How to round up to 5 or 0

CCOLMANT
CCOLMANT
in Modeling

Dear Anaplan Community,

I need help to round numbers up to the nearest number ending in 5 or 0

2233 — to 2235

2888 - to 2890

Any intakes?

Answers

  • JMVasicek
    JMVasicek

    Hi @CCOLMANT,

    One way you could do this would be to divide whatever number you're referring to by 5, round the result to the nearest number, then multiply by 5.

    Effectively: ROUND(Value/5,0) * 5

  • derektslim
    derektslim

    Consider using the Anaplan function MROUND, you may find more info in Anapedia

    The function is similar to Excel's, except with an added flexibility to add a rounding direction too

  • JMVasicek
    JMVasicek

    @derektslim Good point! I actually discovered that formula soon after responding to the original post. :)

Categories