» Rounding the Calculation of Retail Price and Sales Tax
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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:
- The Fall of Advertising and the Rise of PR
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Financial Modeling - 2nd Edition
- Yes, You Can Time the Market!
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Harry Potter and the Order of the Phoenix (Book 5)
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
