Anonymous

What Is The Excel Formula To Figure Out The Subtotal Of A Number If You Know The Tax Rate And The Total? If $355.00 Is The Total, And 6.75% Is The Tax Rate, What Would The Subtotal Be?

2 Answers

Anonymous Profile
Anonymous answered
Hope it helps as cut and paste may not display properly "chicosparadise"
A B C D E F
1 Reverse Calculator Enter Total Amount Below (A2) Result (B2)
2 $40.00 $35.40
3  Formula to enter in cell above (B2)=A2/A8
4
5 0.050 Tax 1 = 5%
6 0.080 Tax 2 = 8%
7 0.130 Total Tax = 13%
8 1.130 add 1 or (100%)
9
 
Anonymous Profile
Anonymous answered
Ok 1st cell = 355.00
next cell = .0675 (= 6.75%)
next cell = 355.00 * .0675
last cell = 355 - above cell
355
0.0675
23.9625
331.0375

Answer Question

Anonymous