I need an Excell function similar to Roudup for Access.

I

Ian Riggall

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

TerryC

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
 
Top