Ravi Sir's Cards › Excel
Credit Card Bill Tracker in Excel (card 2 of 2)
Revision card 2 for Credit Card Bill Tracker in Excel: Overall utilisation: =D10/B10 gives 25.7%; Pay within 5 days: =SUMIF(I6:I9,"Pay now",F6:F9) gives ₹42,300. Includes an example data table.
Read card text
What this card says
2 for Credit Card Bill Tracker in Excel: Overall utilisation: =D10/B10 gives 25.7%
Pay within 5 days: =SUMIF(I6:I9,"Pay now",F6:F9) gives ₹42,300. Includes an
Example
data table
Learn this in the lesson: Credit Card Bill Tracker in Excel: Due Dates, Pending Amount and Credit Utilisation