G Guest Feb 8, 2004 #1 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?
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?
R Roger Govier Feb 8, 2004 #2 Hi Try =ROUND(A1,0) -- Regards Roger Govier gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
Hi Try =ROUND(A1,0) -- Regards Roger Govier gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
P Peo Sjoblom Feb 8, 2004 #3 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 gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
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 gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
B Bob Phillips Feb 8, 2004 #4 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) gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
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) gwalsh2 said: How can I get the TOTAL of a column of numbers (dollars and cents) to Click to expand... round up if 50 or greater or round down if less than 50?
J JE McGimpsey Feb 9, 2004 #5 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)
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)
