ROUNDUP

  • Thread starter Thread starter Guest
  • Start date Start date
In what context. Do you mean apply it to each number so that each number is
actually rounded up, or are you just looking to SUM the numbers assuming thay
have all been rounded up.

For the first, assuming your data in A1:A100, then in B1 put

=ROUNDUP(A1,0) 0 or however many places you want, and then copy down.

If however, you just want to sum all the values as if they had been rounded up,
then in any cell put the following formula and arary enter it using
CTRL+SHIFT+ENTER

=SUM(ROUNDUP($A$1:$A$100,0))

If you have entered it correctly, it will now look like this:-

{=SUM(ROUNDUP($A$2:$A$27,0))}
 
Just to add to Ken's correct answer: you can also use
=SUMPRODUCT(ROUNDUP(A1:A100,0)) which does NOT need to be entered as array
formula. The $ in Ken's formula are optional.
Best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
Cindy Peavy said:
Is there a way to apply the ROUNDUP function to an entire column of
Click to expand...
numbers?
 
Back
Top