» Rounding numerical calculation results in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
We will demonstrate rounding numbers using a simple calculation (cell B1)
Enter the following value in cell A1: 650.00
Enter the following formula in cell B1: =SUM(A1>500,(A1)*0.0865)
The Result: 57.225
Rounding the result to the nearest integer: =ROUND(SUM(A1>500,(A1)*0.0865),0)
Rounding up the result: =ROUNDUP(SUM(A1>500,(A1)*0.0865),0)
Rounding down the result: =ROUNDDOWN(SUM(A1>500,(A1)*0.0865),0)
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The New Financial Order: Risk in the Twenty-First Century
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Word Version 2002 Inside Out
- Financial Statement Analysis with S&P insert card
- Business Plans Kit for Dummies (With CD-ROM)
No comments have been submitted.
