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.
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.