backing sales tax out of a total including sales tax

backing sales tax out of a total including sales tax

Post by dHJlbn » Thu, 25 Aug 2005 13:10:02


I have only Totals including sales tax. I am needing to back out the sales
tax to figure what the sub totals were before applying the 7.75% sales tax.
I can't figure a formula for this task can anyone help me?
 
 
 

backing sales tax out of a total including sales tax

Post by Peo Sjoblo » Thu, 25 Aug 2005 13:38:56

Totals in A1

=A1/1.0775

or more generic if there are other sales tax rates involved, with the sales
tax percentage in B1

=A1/(1+$B$1)

--
Regards,

Peo Sjoblom

(No private emails please)

 
 
 

backing sales tax out of a total including sales tax

Post by dHJlbn » Thu, 25 Aug 2005 15:06:02

thank you, that was so stupidly easy. I guess sometimes you need to take a
look at the box "from the outside".
thank you again.