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?

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