PPRuNe Forums - View Single Post - Excel 2007 multiplication error
View Single Post
Old 28th September 2007 | 07:59
  #8 (permalink)  
izod tester
50 Countries Visited
20 Anniversary
 
Joined: Apr 2002
Posts: 199
Likes: 6
From: Forest of Dean
Not reliably so. If you multipy the result of 850*77.1 then the result will probably be correct (not if the multipland will regenerate the display error), so the result multiplied by 2 will display correctly as 131070. But, if you add 1 to the result, then the number displayed is 100001.

Although my work laptop uses Office 2003, I still don't use any features of Word or Excell which were not available in Office 95 or Word 6. My own PCs use OpenOffice Org, but I am considering trying the new Lotus Symphony which is now on a beta download. That, hopefully will be different to the last version which I used in 1987!
izod tester is offline  
Reply