<div>
Thank you for your response. You got me moving in the right direction. I came up with:<br />
<br />
=('040112'!A34)*(0.16/12)+<wbr />('040112'!<wbr />A34)-('040<wbr />112'!$A$6)<wbr /><br />
<br />
Right now I am only calculating the interest on a monthly basis in the sheet that is right after the statement date. As time goes on I will refine it more, but this gives me a much better idea of how to build my budget.<br />
<br />
Thank you for your help.
</div>


Thank you for your response. You got me moving in the right direction. I came up with:

=('040112'!A34)*(0.16/12)+('040112'!A34)-('040112'!$A$6)

Right now I am only calculating the interest on a monthly basis in the sheet that is right after the statement date. As time goes on I will refine it more, but this gives me a much better idea of how to build my budget.

Thank you for your help.

<div>
<div class="content wysiwyg-content">
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: &nbsp;=('040112'!A34)-('040112'!<wbr />A6)<br />
I would like to add the monthly interest rate to this formula. How to I set that up?
</div>
</div>


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?

excel formula for credit card interest pulling values from diferent spreadsheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.