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.

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

ROUNDDOWN(number,num_digits)

Number is any real number that you want rounded down.
Num_digits is the number of digits to which you want to round number.

Remark

· ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
· If num_digits is greater than 0 (zero), then number is rounded down to the
specified number of decimal places.
· If num_digits is 0 or omitted, then number is rounded down to the nearest
integer.
· If num_digits is less than 0, then number is rounded down to the left of
the decimal point.

Examples

ROUNDDOWN(3.2, 0) equals 3

ROUNDDOWN(76.9,0) equals 76

ROUNDDOWN(3.14159, 3) equals 3.141

ROUNDDOWN(-3.14159, 1) equals -3.1

ROUNDDOWN(31415.92654, -2) equals 31,400
"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.

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.