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)
--
Gary's Student


"Dave Keister" wrote:

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