Ravi Sir's Cards › Excel
Hostel and PG Management System in Excel
Revision card 1 for Hostel and PG Management System in Excel: Paid, Part paid or Unpaid: =IF(H5<=0,"Paid",IF(D5>0,"Part paid","Unpaid")) gives Paid; Rent due date: =B4+B5-1 gives 05-10-2026; Receipt number: ="RC-"&TEXT(ROW()-4,"000") gives RC-001. Includes an example data table.
Read card text
What this card says
1 for Hostel and PG Management System in Excel: Paid, Part paid or Unpaid: =IF(H5<=0,"Paid",IF(D5>0,"Part paid","Unpaid")) gives Paid
Rent due date: =B4+B5-1 gives 05-10-2026
Receipt number: ="RC-"&TEXT(ROW()-4,"000") gives RC-001. Includes an
Example
data table
Learn this in the lesson: Hostel and PG Management System in Excel: Rooms, Residents, Rent, Late Fee, Occupancy and Dashboard