sales tax

G

Guest

I am trying to find a function to calculate sales tax for material sold that
will round off the sales tax to the highest number. ex: for a 10. item the
sales tax at 7.75= .775. I need it to round off to .78. Can anyone help me?
 
G

Guest

Hi Marlene, just after the "=", prefix your existing formula with "ROUND(",
and suffix it with ",2)". eg =ROUND(B3*A1,2)
 
R

Ron Rosenfeld

I am trying to find a function to calculate sales tax for material sold that
will round off the sales tax to the highest number. ex: for a 10. item the
sales tax at 7.75= .775. I need it to round off to .78. Can anyone help me?
Click to expand...


=ROUNDUP(Price*7.75%,2)



--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

backing sales tax out of a total including sales tax 2
A What-if scenario changing one figure to work out another 4
Excel Calculation 4
How do I... 5
SUMIF function in "Price quote with tax calculation" templae 6
Need formula to calculate subtotal before sales tax 4
calculate backwards from agreed upon purchase price to SP inc tax 2
Table_array and drop down boxes 1

Top