Round

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
 
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?
 
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>
 
Top