Ravi Sir's Cards › Excel
Restaurant Management System in Excel (card 2 of 2)
Revision card 2 for Restaurant Management System in Excel: Discount amount: =ROUND(E5*F5,2) gives ₹0.00; GST on the taxable value: =ROUND(H5*Setup!$B$4,2) gives ₹16.00; Bill total, rounded: =ROUND(H5+I5,0) gives ₹336. Includes an example data table.
Read card text
What this card says
2 for Restaurant Management System in Excel: Discount amount: =ROUND(E5*F5,2) gives ₹0.00
GST on the taxable value: =ROUND(H5*Setup!$B$4,2) gives ₹16.00
Bill total, rounded: =ROUND(H5+I5,0) gives ₹336. 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