K
kernel
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$775>DATE(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 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$775>DATE(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