Rounding UP

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

Guest

I have tried rounding using a number of the examples already posted.

I am trying to round up all numbers over #.01

I have tried =Int(([Pallets]+.5)*10)/10 - gives a result of #.5.

I have tried =Round([Pallets],2) - rounds down when less than #.5.

Example: If [Pallets] = 58.25, I need a result of 59.

Thx for the help.
 
Thats the one - Thanks a ton!


--
A MACKENZIE, CMA, MBA


McSummation said:
Have you tried Int(([Pallets]+.99)?

aMack said:
I have tried rounding using a number of the examples already posted.

I am trying to round up all numbers over #.01

I have tried =Int(([Pallets]+.5)*10)/10 - gives a result of #.5.

I have tried =Round([Pallets],2) - rounds down when less than #.5.

Example: If [Pallets] = 58.25, I need a result of 59.

Thx for the help.
Click to expand...
Click to expand...
 

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

Rounding question 1
6 Up Labels, Each Label with Own Detail Band 1
Next Consecutive number 2
Repeat Print 1
Trying again - Header summing problem 6
I need to subtract5 pallets allready inserted. 3
Round up or down to nearest 5, but not 10 2
Possible router problems 9

Back
Top