Hi everyone, my name is Deb, and of course I am in need of expert help again, you've been great in the past and I know I can depend on you this time as well. This is prolly a simple formula but I can't seem to figure out what I need to do. I have a dollar value that I need multiplied by the qty and that total needs to be multiplied by the sales tax percentage to equal a grand total. i.e.
$12.50 X 12=$150.00 x .06%=$9.00 grand total= $159.00
rate/dollar qty sales tax 6% grand total
12.50 12 .06 $159.00
all assistance is appreciated, thank you
$12.50 X 12=$150.00 x .06%=$9.00 grand total= $159.00
rate/dollar qty sales tax 6% grand total
12.50 12 .06 $159.00
all assistance is appreciated, thank you