Ravi Sir's Cards › Excel
Tuition Centre Management System in Excel (card 1 of 2)
Revision card 1 for Tuition Centre Management System in Excel: Months due including the joining month: =(YEAR(Setup!$B$3)-YEAR(D5))*12+MONTH(Setup!$B$3)-MONTH(D5)+1 gives 5; Fee due after discount: =ROUND(G5*F5*(1-E5),0) gives ₹9,000; Paid so far: =SUMIFS(Fees!$D$5:$D$500,Fees!$B$5:$B$500,A5) gives ₹9,000.
Read card text
What this card says
1 for Tuition Centre Management System in Excel: Months due including the joining month: =(YEAR(Setup!$B$3)-YEAR(D5))*12+MONTH(Setup!$B$3)-MONTH(D5)+1 gives 5
Fee due after discount: =ROUND(G5*F5*(1-E5),0) gives ₹9,000
Paid so far: =SUMIFS(Fees!$D$5:$D$500,Fees!$B$5:$B$500,A5) gives ₹9,000.
Learn this in the lesson: Tuition Centre Management System in Excel: Groups, Monthly Fees, Test Marks, Progress Card and Dashboard