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 nu...
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!