how do I round a result (NOT number) up

[monere]

Hi,

I already found out through google how I can round a number up that I manually insert in a cell, but this doesn't help me because I entered a formula (like for example, =sum(a2:a5)) in cell a1, and I'd like this sum to be rounded up to the next normal number (by normal I mean, 3,5, 100, 14, whatever, so no decimal number that is)

Is this possible to do in excel? I have latest version of excel

 

[Aladin Akyurek]

Hi,

I already found out through google how I can round a number up that I manually insert in a cell, but this doesn't help me because I entered a formula (like for example, =sum(a2:a5)) in cell a1, and I'd like this sum to be rounded up to the next normal number (by normal I mean, 3,5, 100, 14, whatever, so no decimal number that is)

Is this possible to do in excel? I have latest version of excel

Try...

=ROUNDUP(SUM(A2:A5,0))

 

[monere]

IT WORKED !! :D

Thanks man!

Try...

=ROUNDUP(SUM(A2:A5,0))

 

[Aladin Akyurek]

IT WORKED !! :D

Thanks man!

You are welcome.