Ravi Sir's Cards › Excel
Vendor Management System in Excel (card 1 of 2)
Revision card 1 for Vendor Management System in Excel: Unpaid balance: =F5-H5 gives ₹32,000; Days overdue: =IF(I5>0,MAX(0,Setup!$B$3-G5),0) gives 32; Billed by vendor: =SUMIFS(Bills!$F$5:$F$60,Bills!$C$5:$C$60,A5) gives ₹4,06,000.
Read card text
What this card says
1 for Vendor Management System in Excel: Unpaid balance: =F5-H5 gives ₹32,000
Days overdue: =IF(I5>0,MAX(0,Setup!$B$3-G5),0) gives 32
Billed by vendor: =SUMIFS(Bills!$F$5:$F$60,Bills!$C$5:$C$60,A5) gives ₹4,06,000.
Learn this in the lesson: Vendor Management System in Excel: Purchase Orders, Bills, Payments, Payable Ageing and Vendor Scorecard