Скачать или смотреть MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705.

Download Excel File: https://excelisfun.net/files/EMT1705....
Learn about the MOD function in the Excel Worksheet and the Number.Mod function in the Power Query M Code language. Learn how to use the MOD function for the Nightshift Hours Worked Payroll Calculation and how to create the Sequential numbers 1, 2, 3, 1, 2, 3.
Topics:
1. (00:00) Intro.
2. (00:09) What is Mod?
3. (00:51) Division formula.
4. (01:11) QUOTIENT Worksheet Function.
5. (01:07) MOD Worksheet Function.
6. (02:12) Use Power Query to divide, quotient and modulo using Add Column built-in options.
7. (03:54) Algorithms for MOD and Number.Mod functions. See why they give different answers.
8. (05:41) Nightshift hours worked formula using MOD function. This time formula works for time calculations that are within a 24 hour day or that crosses midnight.
9. (07:35) Create Patterned Number Sequences such as 1, 2, 3, 1, 2, 3…
10. (08:33) Summary, Closing and Video Links