![]() |
#1
|
|||
|
|||
![]()
I have just found a problem in a very simple spreadsheet (explained below) for which I do not understand the reason.
A1: 7280 A2: 6640 B2: difference formula =A1-A2 [cell displays (640.00)] C2: division formula =614.73/A2 [cell displays .09] D2: multiplication formula =B2*C2 [cell displays 59.25] I inserted these identical cells within an Open Office spreadsheet. The result was the same as above. However, for the cell displaying 59.25, my wife showed a value of 57.60 on her calculator, which matched a manual effort. I changed the D2 formula and instead of using cell C2 (a formula) I used a different cell wherein I manually entered the result of the C2 formula, .09. The result then matched the calculator result of 57.60 Can someone explain what is going on? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel help Formula | sellspeed | Excel | 15 | 03-10-2010 10:57 AM |
![]() |
Corca | Excel | 6 | 02-22-2010 09:40 PM |
![]() |
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
![]() |
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |