title: How to sum cell values in two decimal places
body: <p>One of my columns is formatted as currency until 2 decimal places. When i use add the values up using SUM formula or + , the total is different from what i manually calculated based on two decimal places. E.g. if 1.16 + 2.25 = 3.41, excel will give me a slightly different value. I am guessing this is internal rounding from excel. How to overcome this? I only want to add exactly at two decimal places. Thanks</p>