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