Solved: Excel formula with screwy result

dazedTSG · 03-Oct-2008, 11:45 AM #1

Hi there,
I am trying to figure out why one of my formulas are not producing the correct numbers. Attached is the sheet and the problem can be found in B10. Formula is pretty simple: =B8/B9. B8 is a value of 0.01 and B9 is equal to B6 which has the formula of =((B1/B4)*0.01). Manually calculating the numbers, the answer shold be 1.212562 but the sheet's answer is 1.212499. I don't know why the numbers are off.

Any help is greatly appreciated!

computerman29642 · 03-Oct-2008, 12:39 PM #2

dazed, take a look at the attached file. Look at Column E.

The problem you were having was that even though you set the number in cell B9 to 6 decimal places, it was still dividing the 0.01 number by the entire number in cell B6 (0.008247427).

dazedTSG · 03-Oct-2008, 01:34 PM #3

Thanks Computerman! That was just driving me bonkers. Who knew something little like that would make such a difference.

computerman29642 · 03-Oct-2008, 01:37 PM #4

No Problem!

Glad that I could help.

If you believe the issue has been resolved, please feel free to mark the thread as solved.

Tag Cloud
access acer asus batch bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard mouse network printer problem ram registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!