Ravi Sir's Cards › Excel
Housing Society Maintenance System in Excel (card 1 of 2)
Revision card 1 for Housing Society Maintenance System in Excel: Maintenance for the quarter: =ROUND(Flats!C5*Setup!$B$5*3,0) gives ₹6,825; Sinking fund for the quarter: =ROUND(Flats!C5*Setup!$B$6*3,0) gives ₹488; Parking for the quarter: =IF(Flats!D5="Yes",Setup!$B$7*3,0) gives ₹900.
Read card text
What this card says
1 for Housing Society Maintenance System in Excel: Maintenance for the quarter: =ROUND(Flats!C5*Setup!$B$5*3,0) gives ₹6,825
Sinking fund for the quarter: =ROUND(Flats!C5*Setup!$B$6*3,0) gives ₹488
Parking for the quarter: =IF(Flats!D5="Yes",Setup!$B$7*3,0) gives ₹900.
Learn this in the lesson: Housing Society Maintenance System in Excel: Quarterly Bills, Sinking Fund, Interest on Arrears, Receipts, Expenses and Dashboard