Adding ROUND formula to a selection of cells


M

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top