Hi,

Am sure there is a diff way to write the same formula.
But assuming you want the same formula to work, why dont you try this out?
1) Tools-Options-Calculation tab- Checkbox Iterations. (leave the deaults
as is)
Perhaps that will get the right answer?

--
Tausif Mohammed


"Lynn" wrote:

I am new to Excel. Using Excel 2003. Need help with the following formula:
Cell I43
=If(B40="no",SUM(E16+I16+M16*2)*22+(I43*B42)+(I43* B43)+(I43*B44)
What I do know is that this is a circular reference. It is showing a value
of 535. The value I hoped to see was 518 (I manually did the math). Here is
the referenced cells and values:
Cell E16=10 I16=10 M16=0
Cell B40=no B42=10% B43=0% B44=7.75%
Is there another way to write this formula? Any help or suggestions will be
appreciated. Thanks
--
Lynn