sales tax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marlene - 15 Nov 2005 18:14 GMT

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?

Signature

Reply to this Message

Kassie - 15 Nov 2005 18:22 GMT

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

Signature

j.kasselman@atlantic.net.remove_2nd_at. Stilfontein, Northwest, South Africa

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

Reply to this Message

Ron Rosenfeld - 15 Nov 2005 18:35 GMT

>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

Reply to this Message