On Fri, 18 Dec 2009 01:55:01 -0800, wynand
wrote:

The formula:
=sum(h10,h14,h20,h40)
The result should be:
=sum(4,5,4,4,4,) =21
I however get 20 as a result.
Tools/Options is set to automatic and the "h" cells are formatted as numbers
(1234).
The cells are dependent on other formulas (=sum(h11:h12)/2) etc. The cells
in between is formatted to numbers (1234.10)

Any suggestions anyone

SUM will add the *contents* of the cells. Formatting does not change the
*contents*, only what you see.

So even though you may have a cell formatted as numbers(1234) and you see 1234,
the cell might contain 1233.5 and that is the number SUM will add.

You need to use ROUND if you want the result to equal what you see. You could
also use the Precision as displayed options, but be sure you understand the
consequences.


--ron