Excel Magic Trick 1333

Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding

DESCRIPTION

Learn about Banker’s Rounding or Gaussian Rounding:
(00:15) What is Banker’s Rounding?
(02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding)
(03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and ROUND functions.
(07:11) Power Query’s (Get & Transform) Transform Round option
(08:28) Power Query’s (Get & Transform) Number.Round function
(09:58) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply