Exact Numbers

[mojo300]

is there a way for excel to calulate exact numbers

For example I have a number 3544.64 that i need to put in 3 separate columns equally. When i do this in excel - column B is 1181.55, column C is 1181.55, and column D is 1181.55. But when you add all 3 of those amounts together in reality they come to 3544.65. 1 off. I need it to be exact. I need that last column D to be 1181.54 Any help would be greatly appreciated.

 

[gsistek]

Try:
Column B =ROUND(A1/3,2)
Column C =ROUND(A1/3,2)
Column D =A1-B1-C1

Additional Note: Just because you see 1181.55, the cell may contain 1181.54666666... and is formatted to show only 2 decimal places. Added together, these equal 3544.64, but if you add the displayed numbers (rounded for display only) together its slightly off.

 

[mojo300]

Thank you very much