Ravi Sir's Cards › Excel
Car Service Garage Management System in Excel (card 2 of 2)
Revision card 2 for Car Service Garage Management System in Excel: Line amount: =D5*E5 gives ₹2,400; GST on the line: =ROUND(F5*IF(B5="Part",Setup!$B$5,Setup!$B$6),2) gives ₹432.00; Line key for the invoice: =A5&"-"&COUNTIF($A$5:A5,A5) gives JC-001-1.
Read card text
What this card says
2 for Car Service Garage Management System in Excel: Line amount: =D5*E5 gives ₹2,400
GST on the line: =ROUND(F5*IF(B5="Part",Setup!$B$5,Setup!$B$6),2) gives ₹432.00
Line key for the invoice: =A5&"-"&COUNTIF($A$5:A5,A5) gives JC-001-1.
Learn this in the lesson: Car Service Garage Management System in Excel: Job Cards, Parts and Labour, GST Invoice, Service Reminders and Dashboard