Ravi Sir's Cards › Excel
Housing Society Maintenance System in Excel (card 2 of 2)
Revision card 2 for Housing Society Maintenance System in Excel: Total due: =G5+H5 gives ₹8,213; Receipt number: ="SR-"&TEXT(ROW()-4,"000") gives SR-001; Clear, Due or Overdue: =IF(E5<=0,"Clear",IF(Setup!$B$3>Setup!$B$9,"Overdue","Due")) gives Clear. Includes an example data table.
Read card text
What this card says
2 for Housing Society Maintenance System in Excel: Total due: =G5+H5 gives ₹8,213
Receipt number: ="SR-"&TEXT(ROW()-4,"000") gives SR-001
Clear, Due or Overdue: =IF(E5<=0,"Clear",IF(Setup!$B$3>Setup!$B$9,"Overdue","Due")) gives Clear. Includes an
Example
data table
Learn this in the lesson: Housing Society Maintenance System in Excel: Quarterly Bills, Sinking Fund, Interest on Arrears, Receipts, Expenses and Dashboard