Financial Calculation across sheets

[Guest]

Need some help with a formula.

Sheet1;
A1=$2200
A2=$150.00
A3= $1800
A4=SUM(A1:A3) answer is $4150

Sheet2;
A1=1029514
A2=2663427
A3=(A1/A2) answer is rounded two two decimal places (.39)

Sheet3;
A1=SUM(Sheet1!A4/(1-(Sheet2!A3+.1))) answer comes out $8082.38


Equation should calculate $8137.25 =4150/(1-(.39+.1)

How do I get this to calculate.

Any help would be appreciated.

Thanks

 

[Guest]

Hi Dave:

The problem is the .39 You have adjusted the display to present .39, but
the value Excel is using is 0.386537345

In Sheet2,A3 use =ROUND(A1/A2,2)

 

[Jerry W. Lewis]

As was explained in your other thread 3 days ago, 1029514/2663427 is
0.3865..., not 0.39. If you want Excel to use 0.39 instead of the exact
quotient, you need to either use
=SUM(Sheet1!A4/(1-(ROUND(Sheet2!A3,2)+.1)))
or on the menu select Tools|Options|Calculation and check "Precision as
displayed".

As a practical matter, if you do not understand or or otherwise having a
problem with solutions given in a thread, it better to seek
clarification within that thread instead of starting a new one.

Jerry