» 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:
- The Ernst & Young Business Plan Guide
- Business Plans Kit for Dummies (With CD-ROM)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Mortgages For Dummies®
- Microsoft Office XP Introductory Concepts and Techniques
No comments have been submitted.
