Ravi Sir's Cards › Excel
Library Management System in Excel (card 1 of 2)
Revision card 1 for Library Management System in Excel: Issue number: ="IS-"&TEXT(ROW()-4,"000") gives IS-001; Due date: =B5+Setup!$B$4 gives 15-09-2026; Status: =IF(G5<>"","Returned",IF(Setup!$B$3>F5,"Overdue","Issued")) gives Returned. Includes an example data table.
Read card text
What this card says
1 for Library Management System in Excel: Issue number: ="IS-"&TEXT(ROW()-4,"000") gives IS-001
Due date: =B5+Setup!$B$4 gives 15-09-2026
Status: =IF(G5<>"","Returned",IF(Setup!$B$3>F5,"Overdue","Issued")) gives Returned. Includes an
Example
data table
Learn this in the lesson: Library Management System in Excel: Books, Members, Issue and Return, Due Dates, Late Fines and Availability