sales tax

[marlene]

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?

 

[Kassie]

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

 

[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?

=ROUNDUP(Price*7.75%,2)



--ron