In reply to Rick Wicklin.

Thank you Rick.
It seems there are multiple rules applied in order to get to that type of rounding.

Just wanted to confirm, Formula 100*floor (x/100) would round down to nearest 100. Am I right?