Ravi Sir's Cards › Excel
Library Management System in Excel (card 2 of 2)
Revision card 2 for Library Management System in Excel: Copies available: =D5-E5 gives 2; Times issued: =COUNTIFS(Issues!$D$5:$D$3000,A5) gives 2; Can take more: =MAX(0,Setup!$B$6-D5) gives 2. Includes an example data table.
Read card text
What this card says
2 for Library Management System in Excel: Copies available: =D5-E5 gives 2
Times issued: =COUNTIFS(Issues!$D$5:$D$3000,A5) gives 2
Can take more: =MAX(0,Setup!$B$6-D5) gives 2. 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