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])
 

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 UP 2
Always round up in calculation 2
Excel Stop Excel from displaying rounded values 4
Rounding problem 2
rounding to nearest 5000 4
Rounding UP - always 2
Rounding Up To Even number 1
round up to the next 1/2 kg....formatting 2

Back
Top