how do i roundup multiple cells?

[panamary507]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to roundup multiple cells, I'm using the formula
=ROUNDUP(number,num_digits) It works for the first cell but when I drag it down the result appears to be the same one as the first cell.
Thanks for your help!!

 

[CyberTaz]

Make sure that when you "drag it down" that you're using the Fill Handle at
the lower right corner of the cell. The pointer should look like a black
crosshair -- If it looks like a hand you're actually *moving* the cell
you're dragging rather than copying it.

More likely the problem, however: You didn't indicate what you're actually
using for the NUMBER argument. If you are actually using a certain value as
the argument then that's the number that will be rounded up regardless of
where you copy the formula to. If that's what you've done try using the cell
reference of the cell containing the value to be rounded, so rather than:

=ROUNDUP(3.14,1)

it should be something like:

=ROUNDUP(B1,1) if the value to be rounded is in cell B1.

There are other possible causes, so if neither of these suggestions put it
right you'll need to provide a more explicit description of the data as well
as what specific formula you're writing.

HTH |:>)
Bob Jones
[MVP] Office:Mac