Help with number rounding

[Sithlife]

Hello,

I am trying to calculate numbers using the sum function but sometimes they don't come out whole.

I really need them to round UP to the nearest number - how do I do this when using a formula to get the result?

E.G - =SUM(D7/2)

Thanks in advance!

 

[pgc01]

Hi

Check the help on the function

ROUNDUP()

 

[thisoldman]

Too late.

 

[Jim885]

Your actual formula will be this ...

=ROUNDUP(SUM(D7/2),0.5)

 

[grd]

Personally, I wouldn't use SUM as it is superfluous in that example!

 

[pgc01]

Your actual formula will be this ...

=ROUNDUP(SUM(D7/2),0.5)

Hi Jim

The second parameter of RoundUp() is an integer.