Posted in: Software
lkeiser8517 asked:
I have an excel document that contains several sheets specific to each account. Columns A (Deposits), C (Interest accrued for the month) & E (disbursements) contain dates while columns B, D, & F contain the amounts for each transaction. Column G contains the running total for each month B+D-F. I need a formula that can disperse the amount of interest accrued for the month between the different accounts/sheets assuming there is money in that account at the end of the month in which the interest was earned. For example I accrued $1,146.00 of interest for the month of January 2009. I need a formula to go in column D that divides the $1,146.00 among the different spreadsheets based on each account’s average daily balance on 01/31/2009.
I have an excel document that contains several sheets specific to each account. Columns A (Deposits), C (Interest accrued for the month) & E (disbursements) contain dates while columns B, D, & F contain the amounts for each transaction. Column G contains the running total for each month B+D-F. I need a formula that can disperse the amount of interest accrued for the month between the different accounts/sheets assuming there is money in that account at the end of the month in which the interest was earned. For example I accrued $1,146.00 of interest for the month of January 2009. I need a formula to go in column D that divides the $1,146.00 among the different spreadsheets based on each account’s average daily balance on 01/31/2009.
Thanks!
1
