Rounding to nearest 100

[Stclements]

I wish to round the outcome of the following calculation to the nearest 100.
((C13/Q1)/O1)
I tried mround and round but kept getting different results, any guidance would be greatly appreciated.

Regards

Stclements

 

[mfexcel]

=MROUND(Your value, 100)
is not what you want?

I wish to round the outcome of the following calculation to the nearest 100.
((C13/Q1)/O1)
I tried mround and round but kept getting different results, any guidance would be greatly appreciated.

Regards

Stclements

 

[Stclements]

I have to do the calculation C13/Q1 and then I have to calculate the outcome of that by dividing it by O1 and then rounding the outcome of that calculation. Obviously if it was simply rounding a number it would be as you describe but it is the additional calculation that is giving me the headache.

 

[Shrikant]

=mround(c13/q1/o1,100)

 

[Stclements]

By jove I think you have it old boy.
Jolly well done.