Adding ROUND formula to a selection of cells

[Mike]

Hi

I have a column which contains a many totals. I need to
round the total to -2 eg ROUND(123456,-2). is it possible
to apply the formula to the cells without having to
manually go through them. I have lloked at paste special
but can not see anything that would work. I can not use
the decimal reduction facility as I need to round past the
decimal point.

Please help.

Many thanks

Mike

 

[Jason Morin]

If you want to round each cell first, then sum all these
cells, use:

=SUMPRODUCT(ROUND(A1:A10,-2))

HTH
Jason
Atlatna, GA