Ravi Sir's Cards › Excel
Vendor Management System in Excel (card 2 of 2)
Revision card 2 for Vendor Management System in Excel: Vendor score: =ROUND(50*I5+10*J5,0) gives 90; Vendor grade: =IF(K5>=80,"A",IF(K5>=60,"B","C")) gives A; Unpaid in the bucket: =SUMIFS(Bills!$I$5:$I$60,Bills!$K$5:$K$60,A13) gives ₹2,65,000. Includes an example data table.
Read card text
What this card says
2 for Vendor Management System in Excel: Vendor score: =ROUND(50*I5+10*J5,0) gives 90
Vendor grade: =IF(K5>=80,"A",IF(K5>=60,"B","C")) gives A
Unpaid in the bucket: =SUMIFS(Bills!$I$5:$I$60,Bills!$K$5:$K$60,A13) gives ₹2,65,000. Includes an
Example
data table
Learn this in the lesson: Vendor Management System in Excel: Purchase Orders, Bills, Payments, Payable Ageing and Vendor Scorecard