Ravi Sir's Cards › Excel
Hardware Store Management System in Excel (card 1 of 2)
Revision card 1 for Hardware Store Management System in Excel: Taxable value: =F5*G5 gives ₹170; Line total with GST: =H5+I5 gives ₹200.6; Invoice line key: =B5&"-"&COUNTIF($B$5:B5,B5) gives AH-001-1.
Read card text
What this card says
1 for Hardware Store Management System in Excel: Taxable value: =F5*G5 gives ₹170
Line total with GST: =H5+I5 gives ₹200.6
Invoice line key: =B5&"-"&COUNTIF($B$5:B5,B5) gives AH-001-1.
Learn this in the lesson: Hardware Store Management System in Excel: GST Invoices, Contractor Credit, Ageing, Stock and Dashboard