Thread
:
create a formula for price * discount* tax =final price
View Single Post
#
5
Don Guillett
Posts: n/a
I wish I had a minus tax in Texas
--
Don Guillett
SalesAid Software
"JE McGimpsey" wrote in message
...
Note that this formula results in $8.64, not the OP's $7.36.
In article ,
"Don Guillett" wrote:
try
=(D10*0.8)*1.08
--
Don Guillett
SalesAid Software
"anton" wrote in message
...
I am trying to compute the following: multiply the price times the
discount %
and then subtract that from the price. Then take that answer and
multiply
it
by the tax %. For example price is 10, discount is 20% and tax% is
8%.
price is 8 after discount
multiply 8 times 8% = sales tax
and then subtract that from 8 to get the
final
price of 7.36
Thank You very much for your help
Reply With Quote