Ravi Sir's Cards › Excel
Catering Management System in Excel (card 2 of 2)
Revision card 2 for Catering Management System in Excel: Balance: =L5-M5 gives ₹2,100; Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹42,000; Margin: =J5-O5-P5 gives ₹13,600.
Read card text
What this card says
2 for Catering Management System in Excel: Balance: =L5-M5 gives ₹2,100
Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹42,000
Margin: =J5-O5-P5 gives ₹13,600.
Learn this in the lesson: Catering Management System in Excel: Packages, Events, Payments, Kitchen Quantities, Margin and Dashboard