Скачать или смотреть Excel - Round and MRound Functions in Excel by Chris Menard

Video on ROUNDUP Function
   • ROUNDUP Function in Excel by Chris Menard  

The ROUND function rounds a number to a specified number of digits.

TimeStamps:
00:15 Round 0 decimal place
01:30 Formula Text Function
01:40 Round 1 decimal place
02:15 Round 0 and subtract .01
03:21Round -1
04:40 MRound function used for Timekeeping

Examples:

A1 contains 34.7725, and you want to round that value to two decimal places, you can use the following formula:

=ROUND(A1, 2) The result will be 34.77

A1 contains 34.7725, and you want to round that value to one decimal places, you can use the following formula:

=Round(A1,1)

The result of this function is 34.8

9.42 Rounded one decimal place will be 9.4.
9.46 Rounded one decimal place will be 9.5

The round function has two arguments. The cell reference and the number of decimal places you want to round.

To end all numbers in .99, example the number 23.00, to show .99 would be 22.99. Use the round function and subtract .01. Example: =Round(A1,0)-.01 Be sure to format the cells for two decimal places to see the result.

The MRound function rounds up, away from zero, if the remainder of dividing a number by multiple is greater than or equal to half the value of multiple. Use the MRound function for the 7-minute rule for time clocks. Many employers use a 15-minute clock. Clocking in at 7:07 AM is clocking in at 7:00 AM. Clocking in at 7:08 AM is clocking in at 7:15 AM.

The DOL allows employers to use the 7-minute rule for hourly or non-exempt employees.
DOL Article about the 7-minute rule https://www.dol.gov/whd/regs/complian...

Chris Menard -Website https://chrismenardtraining.com

Microsoft Support Page for Round:
https://support.office.com/en-us/arti...

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!