Calculation
 

try
=(1-0.0775)*L2

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ab3d4u" wrote in message
...

I would like to have a formula that will subtract the sales tax from a
sale. Ex. If I sale a product for $10, I have to charge 7.75% sales
tax. the customer will have to pay me $10.78 in total. I would like to
be able to tell my customers
a) take it $10.50 tax included. I then would like to know how much to
record as sales tax so that I report the exact sales tax.
b) I would like the formula to be flexible enough to allow me to change
prices and offers
c) If you guys can think of any other scenario like if a customer buys
a certain product with this offer and another product at the real
price,, staff like that.
This will be done in the back where the csutomer would not necessarily
see it.
thanks




--
ab3d4u

Calculation
 

Original Price - (Total Price) / ( 1 + Tax)
Example :

Original Price = 10.5 /(1.0775) = 9.74

"ab3d4u" wrote:


I would like to have a formula that will subtract the sales tax from a
sale. Ex. If I sale a product for $10, I have to charge 7.75% sales
tax. the customer will have to pay me $10.78 in total. I would like to
be able to tell my customers
a) take it $10.50 tax included. I then would like to know how much to
record as sales tax so that I report the exact sales tax.
b) I would like the formula to be flexible enough to allow me to change
prices and offers
c) If you guys can think of any other scenario like if a customer buys
a certain product with this offer and another product at the real
price,, staff like that.
This will be done in the back where the csutomer would not necessarily
see it.
thanks




--
ab3d4u

Calculation
 

I would like to have a formula that will subtract the sales tax from a
sale. Ex. If I sale a product for $10, I have to charge 7.75% sales
tax. the customer will have to pay me $10.78 in total. I would like to
be able to tell my customers
a) take it $10.50 tax included. I then would like to know how much to
record as sales tax so that I report the exact sales tax.
b) I would like the formula to be flexible enough to allow me to change
prices and offers
c) If you guys can think of any other scenario like if a customer buys
a certain product with this offer and another product at the real
price,, staff like that.
This will be done in the back where the csutomer would not necessarily
see it.
thanks




--
ab3d4u

Calculation
 

If I understand the OP correctly, he is saying that the 7.75% is applied to
the $10, not to the $10.775, hence it appears that he wants
=L2/(1+0.0775) rather than =(1-0.0775)*L2
--
David Biddulph

"Don Guillett" wrote in message
...
try
=(1-0.0775)*L2

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ab3d4u" wrote in message
...

I would like to have a formula that will subtract the sales tax from a
sale. Ex. If I sale a product for $10, I have to charge 7.75% sales
tax. the customer will have to pay me $10.78 in total. I would like to
be able to tell my customers
a) take it $10.50 tax included. I then would like to know how much to
record as sales tax so that I report the exact sales tax.
b) I would like the formula to be flexible enough to allow me to change
prices and offers
c) If you guys can think of any other scenario like if a customer buys
a certain product with this offer and another product at the real
price,, staff like that.
This will be done in the back where the csutomer would not necessarily
see it.
thanks




--
ab3d4u