• Hi great qod!

    Here's a tip:

    Move the decimal point to the left by the negative number and then do a regular ROUND(d, 0). Applied to this it ends looking like ROUND(0.1666666,0) and there you have it.

    I wish I'd come up with it before I answered incorrectly 🙂

    Regards,

    Hrvoje Piasevoli

    Hrvoje Piasevoli