Excel not calculating correctly

**atakpajr** · 11-08-2011, 03:02 PM

I'm working on a worksheet to determine the amount an employee is to be paid. In one cell I have the amount (N9=29.82) the other the amount of hours (O9=64). In P9 I have the total which is (O9*N9). The problem is that excel returns a total of 1908.76. The actual total is 1908.48.

This is a problem because the math error recurs in all cells with multiplication and I'm trying to link several worksheets for invoicing and will overpay by @ $30 each pay period if I dont go in and manually input the numbers. What can be causing this?

Note. the cells are formated to two digets decimls only.

The Rounding fixed everything, thanks!

**MrShorty** · 11-08-2011, 03:13 PM

Note. the cells are formated to two digets decimls only.

Which begs the question -- what is the actual value in N9? Is it 29.82000000000000000? Or is it something between 29.815 and 29.825? 1908.76/64 would suggest a value in N9 of ~29.8244.

If you want N9 to exactly equal 29.82, you are going to probably have to use the ROUND function (or similar strategy) to force N9 to be exactly 29.82.

**alansidman** · 11-08-2011, 03:16 PM

Are the input cells N9 and O9 harcoded or are they imported? If imported, are they really the numbers you indicated or are they larger with more decimals but only displayed as shown?

Edit: MrShorty has beaten me to the punch on the direction I was headed.