Forum Discussion
Specific Rounding Rules
Howdy! My job has a bit of a weird rule for their rounding technique. I was curious if there is a way I can format my cells or write a function that allows for it.
The rule is as follows:
If the number your rounding is proceeded by a 5, instead of rounding up, you look at the number being rounded. If it is even, you rounding down else you round up.
Basically you want the number your rounding to remain at an even number if it's being rounded by 5.
Is there a way to get this rule into excel?
Thanks in advance for the help!
3 Replies
That's so called Banker's rounding. In Excel environment Power Query uses it by default. If formulae you may google for "excel bankers rounding" for workarounds and samples, e.g. .net - Banker's rounding formula in Excel - Stack Overflow
I'd never heard of "Banker's Rounding," wondered WHY? So for others who've never heard of it and the reason for it, here's what Google told me. And it makes sense!
Can you please give some examples as it's not clear (to me anyway) what you mean.
