Excel Basics #14: ROUND function & Number Formatting

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#14 Video topics:
1)Number formatting only makes it look like numbers are ROUNDED.
2)The ROUND function will round your numbers so that the format and the formula result are the same
3)If your SUMS are not adding up correctly (off by a few pennies), try the ROUND function
4)Payroll deduction formula ROUND function

Category:

Science & Technology

Tags:

• Excel
• ROUND
• function
• formula.
• Payroll
• deduction
• formula
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[jeffnationaltrade]

How would I know when to round or not round number?

[ExcelIsFun]

@jeffnationaltrade , It is only when:

1) You are required to round (like with money or your bosses tell you to)

2) You are multiplying or dividing decimals

3) you will use the formula result in a subsequent formula.

[samthesung]

Thank you for this tutorial. I like the way that you teach it is very easy to understand and you are very knowledgable.

[ExcelIsFun]

@samthesung , you are welcome!

[aadmi67]

You are simply amazing!

[ExcelIsFun]

@aadmi67 , Thanks! I am glad the vids help!

[ExcelIsFun]

I have many videos on rounding:

Excel Magic Trick #237: ROUND to Digit or Multiple

Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ...

Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll

Excel Busn Math 07: When ROUND function Is Required

But none of these cover what you are asking. I do not see a consistent pattern to exploit in your example.

[workwithme2011]

aaaaaaaaaaaaa hi there, how can I round up $1.80 = $2.00, and $1,75= $ 1.00, please help, thanks..........

[ExcelIsFun]

Try formatting to show 2 decimals only.

[warlock4001]

I typed the Round formula as specified but it is returning 143.9600 :S Any idea why this might be?