How do I 'SUM' a column corrected to 2 decimal places from 3

B

barkingmad

I have two columns of data - in column A are quantities of goods (which cost
..025p each), in Column B is the total cost, arrived at by "=A1*.025" etc.
Column B is corrected to 2 decimal places to give a usable finance figure,
but if I SUM column B, instead of adding the figures shown, it adds the
uncorrected amounts (ie 3 decimal places) which ends up in a total which
doesn't match the visible figures. This sounds like it should be quite
simple to correct, I just don't seem to be able to find the answer. I am
using Office 2003 and column B is formatted to exclude zero figures. Hope I
have explained clearly!
 
O

OldJohn

You could expand the formula in B to "=round(A1*.025,2)" so that each
individual line is then accurate to 2 decimal places and the total will be
also.
 
B

Bob Phillips

I don't quite see the problem (they will all be multiples of a quarter,
which can only sum to 2 dec pl as I see it), but maybe this helps

=SUMPRODUCT(ROUND(B1:B20,2))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Similar Threads

Convert 10 Decimal Places to 2 3
how do i show 3 significant figures 1
sum of last 3 figures in a column which also contain empty cells 9
Column total is wrong 5
Sum a range based on a column 2
How do I Limit decimal places in a string cell reference 3
Round to 2 decimal places 2
Need help creating a simple (?) SUM formula! 4

Top