Rounding

[Guest]

How can I get the TOTAL of a column of numbers (dollars and cents) to round up if 50 or greater or round down if less than 50?

 

[Roger Govier]

Hi

Try
=ROUND(A1,0)

--
Regards
Roger Govier

How can I get the TOTAL of a column of numbers (dollars and cents) to

round up if 50 or greater or round down if less than 50?

 

[Peo Sjoblom]

If you mean rounding to nearest 100

=ROUND(A1,-2)

if you mean rounding the cents to the nearest dollar

=ROUND(A1,0)

where A1 holds the total

--

Regards,

Peo Sjoblom

How can I get the TOTAL of a column of numbers (dollars and cents) to

round up if 50 or greater or round down if less than 50?

 

[Bob Phillips]

If you just want to round the total, then
=ROUND(SUM(A1:A4),0)

If you want to round each entry before totalling, use
=SUM(ROUND(A1:A4,0))
which is an array formula, so enter with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

How can I get the TOTAL of a column of numbers (dollars and cents) to

round up if 50 or greater or round down if less than 50?

 

[JE McGimpsey]

I read this post a bit differently than some of the outhers you received:

=IF(SUM(A1:A10)>=50,ROUNDUP(SUM(A1:A10),0),ROUNDDOWN(SUM(A1:A10),0))

or, perhaps

=ROUNDUP(SUM(A1:A10),0) - (SUM(A1:A10) < 50)