» 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 Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Special Edition Using Microsoft Access 2002
- Marketing Management
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
