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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Roundup Function 1
Rounding Up question 2
Total is off by a couple of cents 4
Rounding problem 2
Number Field Automatically Rounding Decimals 3
INT to ROUNDUP 5
How can I round a number to 2 significant figures 2
Run report on the 5th of every month automatically 0

Back
Top