Ravi Sir's Cards › Excel
School Fee Management System in Excel (card 2 of 2)
Revision card 2 for School Fee Management System in Excel: Up to date, Nothing paid or Overdue: =IF(G6=0,"Up to date",IF(F6=0,"Nothing paid","Overdue")) gives Up to date; Due till date: =ROUND(D6*$B$3/4,0) gives ₹30,750; Paid so far: =SUMIFS(Receipts!$F$5:$F$800,Receipts!$C$5:$C$800,A6) gives ₹33,000. Includes an example data table.
Read card text
What this card says
2 for School Fee Management System in Excel: Up to date, Nothing paid or Overdue: =IF(G6=0,"Up to date",IF(F6=0,"Nothing paid","Overdue")) gives Up to date
Due till date: =ROUND(D6*$B$3/4,0) gives ₹30,750
Paid so far: =SUMIFS(Receipts!$F$5:$F$800,Receipts!$C$5:$C$800,A6) gives ₹33,000. Includes an
Example
data table
Learn this in the lesson: School Fee Management System in Excel: Fee Structure, Instalments, Overdue List, Receipts and Dashboard