D
Don Guillett
try
=(1-0.0775)*L2
=(1-0.0775)*L2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dhstein
Original Price - (Total Price) / ( 1 + Tax)
Example :
Original Price = 10.5 /(1.0775) = 9.74
Example :
Original Price = 10.5 /(1.0775) = 9.74
A
ab3d4u
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
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
D
David Biddulph
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
the $10, not to the $10.775, hence it appears that he wants
=L2/(1+0.0775) rather than =(1-0.0775)*L2