I have spreadsheets setup that has every 1st and 15th of every month in one workbook. A cell in the current time period pulls the value of one cell and subtracts the payment amount from a different cell of the previous time period. The formula looks like this: =('040112'!A34)-('040112'!A6)
I would like to add the monthly interest rate to this formula. How to I set that up?