e07p1Furniture_LastFirst Furniture Sales 10 Points Deducted Score: Point Value 0.2 Name 0.5 0.5 6 Step Description 7 a Save e07p1Furniture as e07p1Furniture LastFirst Cul: WEEKDAY[B11,1) 8b Copy function to range C12:C113 011: =SWITCH(C11,1,E$2,2.E$3,3,E$4,4,E$5,5,E$6,6, E$7,7,6$8) 9 Copy function to range D12:0113 H11: [NOT[F11="Finance"),611,611C$3) 10 d Copy function to range H12:H113 11e 111:=G11-H11: copy to range 112:1113 121 111: =1F[111>0. EDATE B11, CSA),""); copy to range 112: 113 13 g 12: COUNTIE 11:5113,"Paid in Full") 14 h 33: SUMIFF11:F113,"Paid in Full" G11 G113) 15 14: AVERAGEIF(11:5113,"Paid in Full".G11:6113) S: AVERAGEIFS(G11:G113,F11F113,"Paid in 16 Full" 11:6113,"4000" 16: MAXIES(G11:6113,F11F113,"Paid in Full" 11:6113.">4000") March 1 Loans sheets 85: FV[2.E5,-34) UTICE CE D2 1721 07p1Furniture 05 0.5 0.5 05 0.5 0.5 0.5 0.5 17 05 O i Type here to search e07p1Furniture_LastFirst Furniture Sales 10 Points Deducted Score: Point Value 0.2 Name 0.5 0.5 6 Step Description 7 a Save e07p1Furniture as e07p1Furniture LastFirst Cul: WEEKDAY[B11,1) 8b Copy function to range C12:C113 011: =SWITCH(C11,1,E$2,2.E$3,3,E$4,4,E$5,5,E$6,6, E$7,7,6$8) 9 Copy function to range D12:0113 H11: [NOT[F11="Finance"),611,611C$3) 10 d Copy function to range H12:H113 11e 111:=G11-H11: copy to range 112:1113 121 111: =1F[111>0. EDATE B11, CSA),""); copy to range 112: 113 13 g 12: COUNTIE 11:5113,"Paid in Full") 14 h 33: SUMIFF11:F113,"Paid in Full" G11 G113) 15 14: AVERAGEIF(11:5113,"Paid in Full".G11:6113) S: AVERAGEIFS(G11:G113,F11F113,"Paid in 16 Full" 11:6113,"4000" 16: MAXIES(G11:6113,F11F113,"Paid in Full" 11:6113.">4000") March 1 Loans sheets 85: FV[2.E5,-34) UTICE CE D2 1721 07p1Furniture 05 0.5 0.5 05 0.5 0.5 0.5 0.5 17 05 O i Type here to search