Sum using displayed values not calculated values

F

forss1

I hope this question makes sense to someone! I've carried out a series of
calculations in Excel ( Office 2003). The answers were to 4 decimal places,
which I changed so that only 2 decimal places were displayed. Can I now get
Excel to carry out a sum of these displayed figures ( 2 decimal places) as at
the moment everytime I try to do this it uses the figures it calculated
originally (4 decimal places). Alternatively, can I get it to calculate the
original answer to 2 decimal places?
 
F

Frank Kabel

Hi
either you could use round on each single formula or try the array
formula
=SUM(ROUND(A1:A10,2))
 
B

Bob Phillips

=SUM(ROUND(H1:H2,2))

This is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

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