How do I make a cell round to another cell?

  • Thread starter Thread starter Aaron
  • Start date Start date
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.
 
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.
 
MROUND doesn't automatically round down; it rounds to the *nearest*. It is
FLOOR that rounds down (analagous to CEILING rounding up).
 
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.
 
Back
Top