Ravi Sir's Cards › Excel
Restaurant Management System in Excel (card 1 of 2)
Revision card 1 for Restaurant Management System in Excel: Line key: bill no and line number: =A5&"-"&COUNTIF($A$5:A5,A5) gives R-1001-1; Food cost % of the dish: =E7/D7 gives 31.7%; Subtotal of the bill: =SUMIFS(Orders!$I$5:$I$200,Orders!$A$5:$A$200,A5) gives ₹320. Includes an example data table.
Read card text
What this card says
1 for Restaurant Management System in Excel: Line key: bill no and line number: =A5&"-"&COUNTIF($A$5:A5,A5) gives R-1001-1
Food cost % of the dish: =E7/D7 gives 31.7%
Subtotal of the bill: =SUMIFS(Orders!$I$5:$I$200,Orders!$A$5:$A$200,A5) gives ₹320. Includes an
Example
data table
Learn this in the lesson: Restaurant Management System in Excel: Menu, Orders, GST Bills, Printable Bill, Food Cost and Sales Dashboard