miscalculation in excel "GSHEP" <g.shepherd[ at ]zoom.co.uk> 30.09.2006 12:26:30 adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04

RE: miscalculation in excel JLatham 30.09.2006 14:07:01 Excel 2003 says 989.89+165.2 is 1155.09 G23 contains 989.89 H23 contains 165.2 I23 set as =G23+H23 shows 1155.09 Something else in the formula you're using? "GSHEP" wrote: [Quoted Text] > adding 989.89 to 165.2 > cells G23 H23 > > > =G23+H23 in spreadsheet > > answer should be 1155.09 calculation given is 1155.04 > >

Re: miscalculation in excel Gord Dibben <gorddibbATshawDOTca> 30.09.2006 15:45:42 Answer should be 1154.91 using just the figures supplied. Increase decimal places in the two cells and see what you really have in G23 and H23 John McGimpsey has some info at this site http://www.mcgimpsey.com/excel/pennyoff.html Gord Dibben MS Excel MVP On 30 Sep 2006 05:26:30 -0700, "GSHEP" <g.shepherd[ at ]zoom.co.uk> wrote: [Quoted Text] >adding 989.89 to 165.2 > cells G23 H23 > > >=G23+H23 in spreadsheet > >answer should be 1155.09 calculation given is 1155.04

Re: miscalculation in excel Ron Rosenfeld <ronrosenfeld[ at ]nospam.org> 30.09.2006 20:54:11 On 30 Sep 2006 05:26:30 -0700, "GSHEP" <g.shepherd[ at ]zoom.co.uk> wrote: [Quoted Text] >adding 989.89 to 165.2 > cells G23 H23 > > >=G23+H23 in spreadsheet > >answer should be 1155.09 calculation given is 1155.04 Then the contents of G23 and H23 is not 989.89 and 165.2 Format the G23 and H23 as General, or Number with a lot of decimal places, and see what the contents of those cells is really. --ron