» 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)
Screenshot // Rounding the Calculation of Retail Price and Sales Tax