Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2010, 10:24 AM
markg2 markg2 is offline Formula problem? Windows 7 Formula problem? Office 2007
Expert
Formula problem?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Formula problem?

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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Formula problem? Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Formula problem? If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Formula problem? Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft