MROUND Problem

[dark11984]

I'm trying to round up a number to the nearest multiple of another number. I can do this with MRound if i want the multiple to be a fixed amount however i need the multiple to refer to a cell reference.

In this example, multiples are 100 and 50. In row 1 i want 47 to be rounded up to 100 and row 2 rounded up to 50. Is this possible?


A B C
1 100 47 100
2 50 47 50

Thanks

 

[barry houdini]

MROUND rounds to the nearest multiple so if you round 47 to the nearest multiple of 100 you'll get 0

Having said that you can use a cell reference in MROUND so if A2 = 100 and B2 = 47 you can use

=MROUND(B2,A2)

If you always want to round up try CEILING, i.e.

=CEILING(B2,A2)

 

[dark11984]

ceiling worked great. Thanks mate.