取引先	財務データ						信用度		計算値(千円)		与信枠(千円)
	流動資産(百万円)	流動負債(百万円)	流動比率(%)	自己資本(百万円)	総資本(百万円)	自己資本比率(%)	基準1	基準2	基準1での計算値	基準2での計算値	
K1	491	351	=RC[-2]/RC[-1]*100	60	497	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K2	1011	742	=RC[-2]/RC[-1]*100	275	553	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K3	855	680	=RC[-2]/RC[-1]*100	301	818	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K4	587	800	=RC[-2]/RC[-1]*100	50	211	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K5	1347	976	=RC[-2]/RC[-1]*100	292	706	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K6			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K7			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K8			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K9			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K10			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K11			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K12			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K13			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K14			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K15			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K16			=RC[-2]/RC[-1]*100			=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K17	2330	1900	=RC[-2]/RC[-1]*100	200	397	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K18	1829	1722	=RC[-2]/RC[-1]*100	267	852	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K19	433	380	=RC[-2]/RC[-1]*100	310	1087	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K20	739	532	=RC[-2]/RC[-1]*100	444	1167	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))
K21	543	489	=RC[-2]/RC[-1]*100	59	430	=RC[-2]/RC[-1]*100	=VLOOKUP(RC[-4],信用度評価基準!R2C4:R6C5,2,TRUE)	=VLOOKUP(RC[-2],信用度評価基準!R7C4:R11C5,2,TRUE)	=(RC[-8]-RC[-7])*VLOOKUP(RC[-6],信用度評価基準!R2C4:R6C6,3,TRUE)*1000	=RC[-6]*VLOOKUP(RC[-4],信用度評価基準!R7C4:R11C6,3,TRUE)*1000	=IF(MIN(RC[-2]:RC[-1])<0,0,MIN(RC[-2]:RC[-1]))