Sum of numbers with decimals.

[anuselesscharacter]

Hello, I'm having a problem in addition of numbers with decimals. I have attached a sample workbook which consists of two columns A & B. Both column have same numbers but column A consists of formula whereas column B doesn't have any formula. The thing is sum of both columns are different. It is because every cells in column A have formula and the value is returned into decimal numbers.

Example:
A1=15360/31*11 which returns value 5450.32258064516
So, excel sums all decimal in column A and returns value which if compared to column B is different.

What I want is to sum only two digit after decimal and return value like in B12 and also I want every cell to show their respective formulas too.

[FDibbins]

You would need to use ROUND() for this. I put this in D1 and copied down...
=ROUND(A1,2)

[FDibbins]

Please do not post duplicate threads - I have closed your other 1

[AliGW]

Try this:

=ROUND(15360/31*11,2)

[anuselesscharacter]

I have to even show formula in the cells i.e. 15360/31*11
Sorry, due to internet issue next thread was also created, kindly delete that.

Thanks Ali, it worked.

[GeoffW283]

I have to even show formula in the cells i.e. 15360/31*11

To show the formulas:
Ribbon > Formulas > Show Formulas

If you need to show the formulas in a "normal" view then make these additional steps.

1. Format column-C as 'Text"
2. With formulas showing, copy col-A
3. Paste into an empty MS-Word document
4. In MS-Word, select what you just pasted in.
5. Copy
6. Paste as Text into Excel col-C
7. Deselect Show Formulas

Column-C should now still show your formulas.

Note that this is only a "static" one-off workaround only. If you now change any of your col-A formulas then these changes will not be reflected in col-C.