Rounding Sum to Nearest 100

[Andrew Hardscape]

Hello All!

I am sure this question has come up numerous times. I have a cell that displays the sum of numbers
=P7-P8

I want to round the sum to the nearest 100

Example: $2,550 I want rounded UP to $2,600.00 (the nearest 100)

or $9,249 I want rounded DOWN to the $9,200.00 (the nearest 100)

Can anyone be so kind to provide me with the code?

Thanks in advance!

 

[zaska]

Try!

=MROUND(X,100)

 

[Rick Rothstein]

Try!

=MROUND(X,200)

I think you have a typo... I believe that 200 should actually be 100.

 

[Andrew Hardscape]

ok thanks! But how but including the sum aspect?

I want to sum P7-P8 and I want to round up or down as well

 

[zaska]

=MROUND(p7-p8,100)

 

[Andrew Hardscape]

Thank You Everyone!

 

[r1998]

Hello
try this

=ROUND(SUM(P7:P8),-2)

 

[TotallyConfused]

Hello Andrew

I hope this is what you are looking for.

=MROUND(SUM(P7-P8),100)

TotallyConfused

 

[Rick Rothstein]

Hello Andrew

I hope this is what you are looking for.

=MROUND(SUM(P7-P8),100)

Why are you using the SUM function for a straight subtraction of two numbers? Once you remove the SUM function call, your formula would become the same as the one zaska posted in Message #5 .

 

[zaska]

@Andrew Hardscape

Please use this formula , it takes care of the negative values too in case P7 < P8

=MROUND(P7-P8,IF(P7-P8>0,100,-100))