Rounding question

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

Hello,

I have created a report that calculates how many shipping pallets is needed
for a particular shipment. I need the result to always round up.
Currently, if the result is 1.1 it rounds to 1... But I need it to always
round up, in this case to 2.

Any suggestions on how to do this?

Many thanks!

Helen
 
The Int() function rounds down, so you can round up by negating the result,
using Int() and then negating again.

Try:
= - Int( - [your calculation here])
 
Back
Top