LinkBack URL
About LinkBacks
On the PROPOSAL tab, at I41, a simple multiplication instruction is wrong. It's multiplying 72*186.53 which = 13430.16 in the real world, but on this sheet 11 cents are missing.
I'm pulling my hair out on this one....
On the PROPOSAL tab, at I41, a simple multiplication instruction is wrong. It's multiplying 72*186.53 which = 13430.16 in the real world, but on this sheet 11 cents are missing.
I'm pulling my hair out on this one....
Last edited by JBeaucaire; 11-08-2008 at 02:13 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It's a feature, not a bug.
I dunno what to say...
If I manually type in 186.53 into cell F41, the error disappears. Why is the formulaic retrieval of the same number allow 11 cents to disappear?
It's because the value in that cell is really 186.52841592 and not 186.53.
72 of those 0.00158408's add to to the 11 cents that is missing.
Now, how to change that.... not sure yet.
Change F41 to beto make the value to be the expected 186.53.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks