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

One mo

=TRUNC(A1,2)

Biff

"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.