Ravi Sir's Cards › Excel
Insurance Policy Renewal Tracker in Excel (card 2 of 2)
Revision card 2 for Insurance Policy Renewal Tracker in Excel: Status: =IF(I6<0,"Overdue",IF(I6<=30,"Due soon","OK")) gives Due soon; Per month to set aside: =N6/12 gives ₹6,979; Money needed in 30 days: =SUMIFS(D6:D11,I6:I11,">=0",I6:I11,"<=30") gives ₹38,650. Includes an example data table.
Read card text
What this card says
2 for Insurance Policy Renewal Tracker in Excel: Status: =IF(I6<0,"Overdue",IF(I6<=30,"Due soon","OK")) gives Due soon
Per month to set aside: =N6/12 gives ₹6,979
Money needed in 30 days: =SUMIFS(D6:D11,I6:I11,">=0",I6:I11,"<=30") gives ₹38,650. Includes an
Example
data table
Learn this in the lesson: Insurance Policy Renewal Tracker in Excel: Next Premium Due Date with EDATE and Yearly Cost