Int (integer function)

[alex richardson]

When I use this function it simply chops off the decimal
positions. Is there a way to get it to round to the
nearest dollar before it truncates the decimals?

 

[Guest]

Instead of Int(xxx) use Round(xxx,0)

 

[Michael J. Strickland]

When I use this function it simply chops off the decimal
positions. Is there a way to get it to round to the
nearest dollar before it truncates the decimals?

You want the round function:


Round(expression [,numdecimalplaces])


--

 

[Mike Labosh]

Instead of Int(xxx) use Round(xxx,0)

heh. I 'm so old-school that I still catch myself doing Int(x + .5)
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"

 

[Guest]

Mike, Don't feel bad, that was my first reaction too.