Ravi Sir's Cards › Excel
Hardware Store Management System in Excel (card 2 of 2)
Revision card 2 for Hardware Store Management System in Excel: Outstanding: =C5-D5 gives ₹8,130.00; Billed to the customer: =SUMIFS(Invoices!$J$5:$J$3000,Invoices!$C$5:$C$3000,A5) gives ₹98,530.00; Over 60 days: =E5-F5-G5 gives ₹0.00.
Read card text
What this card says
2 for Hardware Store Management System in Excel: Outstanding: =C5-D5 gives ₹8,130.00
Billed to the customer: =SUMIFS(Invoices!$J$5:$J$3000,Invoices!$C$5:$C$3000,A5) gives ₹98,530.00
Over 60 days: =E5-F5-G5 gives ₹0.00.
Learn this in the lesson: Hardware Store Management System in Excel: GST Invoices, Contractor Credit, Ageing, Stock and Dashboard