=if(average(C4:C23)>=1.5, AND(D4<=0.1), (SUM(C4:C23)*3.75), IF(average(C4:C23)>=1.5, AND(0.1<D4<=0.2), (SUM(C4:C23)*7.5), IF(average(C4:C23)>=1.5, AND(0.3<D4<=0.4), (SUM(C4:C23)*18.75), IF(average(C4:C23)>=1.5, AND(0.4<D4), (SUM(C4:C23)*22.5), IF(average(C4:C23)>=1.5, AND(0.2<D4<=0.3), (SUM(C4:C23)*15), 0)))))