Int (integer function)

  • Thread starter alex richardson
  • Start date
A

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

Michael J. Strickland

alex richardson said:
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?
Click to expand...

You want the round function:


Round(expression [,numdecimalplaces])


--
 
M

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