» Rounding the Calculation of Retail Price and Sales Tax
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Calculating the retail price and sales tax (7.75 percent) for each price in column A.
Solution:
To calculate Retail Price use the ROUND function in the following formula:
=ROUND(A2/(1+7.75%),2)
To calculate Sales Tax use the ROUND function in the following formula:
=ROUND(7.75%*B2,2)

Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- The Basics of Finance: Financial Tools for Non Financial Managers
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Now, Discover Your Strengths
- PowerPoint® 2002 For Dummies®
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.

