Home / Discussions

Reply to Message

RE: Office challenge: Why is SUM() returning different results for the same values?
At least two possible reasons
1) Cells C1 to C3 contain numbers between 0.5 and 0.8 but column is formatted as 0 decimal places
2) Cells C1 to C3 all conyain 1 but C3 is formarres as right-aligned text
Posted by Bob G Beechey
18th Jan 2011