How do I make a cell round to another cell?

[Aaron]

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.

 

[JE McGimpsey]

One way:

A1: 0.02

B2: 0.05
C2: =ROUND(B2/$A$1,0)*$A$1

 

[David Biddulph]

=MROUND(Answercell,Keycell).

 

[ilia]

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.

 

[David Biddulph]

MROUND doesn't automatically round down; it rounds to the *nearest*. It is
FLOOR that rounds down (analagous to CEILING rounding up).

 

[Aaron]

MROUND doesn't automatically round down; it rounds to the *nearest*. It is
FLOOR that rounds down (analagous to CEILING rounding up).
--
David Biddulph








- Show quoted text -

Thankyou everyone for your help, I will put these to the tst on my
spreadsheet.

Cheers,

Aaron.