round up the sum of a range of numbers to the nearest 100

[Laura]

I am trying to round the sum of a small range of numbers up to the nearest
100...nothing I try seems to work...please show me the proper way to write
the formula

 

[NHarkawat]

to round it up to nearest 100 use
=ceiling(a1,100)
to round it down
=floor(a1,100)

 

[CarlosAntenna]

=MROUND(A1,100)

 

[mzehr]

Hi Laura,
Try
=ROUND(A1,-2)to round to nearest 100
=ROUND(A1/0.01,0)*0.01 or =ROUND(A1*100,0)/100 to round to nearest 1/100

 

[Bob Phillips]

Laura,

For more information than you can handle, take a look at
http://www.xldynamic.com/source/xld.Rounding.html

 

[Frank Kabel]

Hi
=ROUNDUP(A1,-2)

 

[mzehr]

Sorry Laura,
I misread your post about rounding Up
Use the ceiling function
=CEILING(A1, 100)

 

[Bob Phillips]

You could have used ROUNDUP the same way.