CEILING(Answercell, Keycell)

Will (always) round up to the nearest multiple of Keycell. Use MROUND
if you need it to round down, otherwise this works.


On Aug 9, 4:00 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=MROUND(Answercell,Keycell).
--
David Biddulph

"Aaron" wrote in message

ups.com...



Hi,

How can I make a cell with a number in it round to another cells
number.

IE Keycell is 0.02 and Answercell is 0.05 but I need it to only show
numbers in multiples of the Keycell so in this example it would round
up to 0.06?

Cheers,

Aaron.- Hide quoted text -

- Show quoted text -