» 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:
No comments have been submitted.
