Rounding UP

A

aMack

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.
 
A

aMack

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...
 
Top