I need an Excell function similar to Roudup for Access.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to roundup to the second decimal in my reports. Access' "Round"
follows nomal rounding convetions. I need to round up all resrults.
 
Ian,

Have a look at the int and fix functions. (From memory) you need to stuff
around with your value to get the desired rounding (roundup / rounddown) by
multiplying by -1 and or 100 and then dividing the result by 100. Post back
if this doesn't help and I'll try and find where I used this and expand a bit.

HTH,

Terry
 
Back
Top