Round

[Guest]

Is there any simple way to round?

 

[Guest]

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

 

[Joseph Meehan]

Is there any simple way to round?

Many. Are you particular about what form of rounding you want?

 

[Guest]

It's for a dollar amount and I just want to round to the whole dollar. Is
there a simple expression I can use?

 

[Joseph Meehan]

It's for a dollar amount and I just want to round to the whole
dollar. Is there a simple expression I can use?

OK how about this question

$1.00 = 1

$1.01 = ?? $1 or $2

$1.49 = ?? $1 or $2

$1.50 = ?? $1 or $2

$1.51 = ?? $1 or $2

$1.99 = ?? $1 or $2

Those answers are all correct depending on the rounding you want.

 

[arista via AccessMonster.com]

Hi

some time ago I had little bit different problem also asociated to rounding
and this page I found very interesting :

http://ewbi.blogs.com/develops/2003/11/vba_round_yet_a.html

Good luck as you might need it !

 

[Guest]

It should be something like:
$1.50 = $1
$1.51= $2

 

[Joseph Meehan]

It should be something like:
$1.50 = $1
$1.51= $2

That is called banker's rounding

http://en.wikipedia.org/wiki/Rounding

Additional information on Rounding in Access can be found at:

http://ewbi.blogs.com/develops/2003/11/vba_round_yet_a.html

 

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

 

[Joseph Meehan]

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

Now that I think about it, you are right. I have been out of the
business too long. (Thank God)