Need Help Resolving Circular Ref
 

Hi,

Need some help to resolve my circular reference problem. I have a worksheet
where I am trying to model different scenarios with my mortgage.

Column A contains the interest rate ie
Column C contains the date (I have 1 row for every date between 20-may-08
and 30-jun-10)
Column D conatians my regular weekly and fortnightly payment amounts
Column E contains my mortgage balance formula =E37+D38-G38
Column F contains the daily interest calculation =(E38*A38)/366
Column G contains the monthly interest total calculation (it is always
charged on the 23rd of the month)
=IF(DAY(C38)=23,SUMPRODUCT(($C$4:$C$775<=C38)*($C$ 4:$C$775DATE(YEAR(C38),MONTH(C38)-1,23)),$F$4:$F$775),0)

Any suggestions on how I can change the sheet to stop the circular issue
would be much appreciated.

Cheers,

kernel

Need Help Resolving Circular Ref
 

bump

"kernel" wrote:

Hi,

Need some help to resolve my circular reference problem. I have a worksheet
where I am trying to model different scenarios with my mortgage.

Column A contains the interest rate ie
Column C contains the date (I have 1 row for every date between 20-may-08
and 30-jun-10)
Column D conatians my regular weekly and fortnightly payment amounts
Column E contains my mortgage balance formula =E37+D38-G38
Column F contains the daily interest calculation =(E38*A38)/366
Column G contains the monthly interest total calculation (it is always
charged on the 23rd of the month)
=IF(DAY(C38)=23,SUMPRODUCT(($C$4:$C$775<=C38)*($C$ 4:$C$775DATE(YEAR(C38),MONTH(C38)-1,23)),$F$4:$F$775),0)

Any suggestions on how I can change the sheet to stop the circular issue
would be much appreciated.

Cheers,

kernel