How do I make a cell round to another cell?

A

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.
 
I

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.
 
D

David Biddulph

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

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 -
Click to expand...

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

Cheers,

Aaron.
 
Top