View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How do I round down a tax percentage

=FLOOR(A1,0.01)

where A1 holds the value

--
Regards,

Peo Sjoblom

(No private emails please)


"Bill" wrote in message
...
Once I calcaulate a tax rate, if the end result is $5.968, it
automatically
rounds up when a final total is calculated. I do not want this to happen.
I
need it to round down to 5.96.