Thread: sales tax
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kassie
 
Posts: n/a
Default sales tax

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


"marlene" wrote:

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