Problem:
Calculating the retail price and sales tax (7.75 percent) matching each total price in column A.
Solution:
Using the ROUND function, as follows:
To calculate Retail Price:
=ROUND(A2/(1+7.75%),2)
To calculate Sales Tax:
=ROUND(7.75%*B2,2)
Problem:
Calculating the retail price and sales tax (7.75 percent) matching each total price in column A.
Solution:
Using the ROUND function, as follows:
To calculate Retail Price:
=ROUND(A2/(1+7.75%),2)
To calculate Sales Tax:
=ROUND(7.75%*B2,2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks