P
pgarcia
Is there any simple way to round?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer Cohen
Function Round or Int Or Format
Round(2.44) will return 2
Round(2.55) will return 3
Round(2.55,1) will return 2.6
Round(2.54,1) will return 2.5
Int(2.44) will return 2
Int(2.55) will return 2
Format(2.55,"#") will return 3
Format(2.44,"#") will return 2
Round(2.44) will return 2
Round(2.55) will return 3
Round(2.55,1) will return 2.6
Round(2.54,1) will return 2.5
Int(2.44) will return 2
Int(2.55) will return 2
Format(2.55,"#") will return 3
Format(2.44,"#") will return 2
P
pgarcia
It's for a dollar amount and I just want to round to the whole dollar. Is
there a simple expression I can use?
there a simple expression I can use?
P
pgarcia
It should be something like:
$1.50 = $1
$1.51= $2
$1.50 = $1
$1.51= $2
D
Douglas J. Steele
<quibble>
That's not Banker's Rounding. Banker's Rounding always rounds .5 to the
closest even value. In other words, it would round both $1.50 and $2.50 to
$2.
</quibble>
That's not Banker's Rounding. Banker's Rounding always rounds .5 to the
closest even value. In other words, it would round both $1.50 and $2.50 to
$2.
</quibble>