Cell | Formula | I4 | =IF(ISBLANK(F4)=TRUE, "",F4-C4) | J4 | =IF(ISBLANK(G4)=TRUE, "",G4-C4) | K4 | =IF(ISBLANK(H4)=TRUE, "",H4-C4) | L4 | =LOOKUP(D4,{1,2,3,4,5},{"0","3","3","14","30"}) | M4 | =IF(MAX(I4:K4)<=L4,"No","Yes") | I5 | =IF(ISBLANK(F5)=TRUE, "",F5-C5) | J5 | =IF(ISBLANK(G5)=TRUE, "",G5-C5) | K5 | =IF(ISBLANK(H5)=TRUE, "",H5-C5) | L5 | =LOOKUP(D5,{1,2,3,4,5},{"0","3","3","14","30"}) | M5 | =IF(MAX(I5:K5)<=L5,"No","Yes") | I6 | =IF(ISBLANK(F6)=TRUE, "",F6-C6) | J6 | =IF(ISBLANK(G6)=TRUE, "",G6-C6) | K6 | =IF(ISBLANK(H6)=TRUE, "",H6-C6) | L6 | =LOOKUP(D6,{1,2,3,4,5},{"0","3","3","14","30"}) | M6 | =IF(MAX(I6:K6)<=L6,"No","Yes") | I7 | =IF(ISBLANK(F7)=TRUE, "",F7-C7) | J7 | =IF(ISBLANK(G7)=TRUE, "",G7-C7) | K7 | =IF(ISBLANK(H7)=TRUE, "",H7-C7) | L7 | =LOOKUP(D7,{1,2,3,4,5},{"0","3","3","14","30"}) | M7 | =IF(MAX(I7:K7)<=L7,"No","Yes") | I8 | =IF(ISBLANK(F8)=TRUE, "",F8-C8) | J8 | =IF(ISBLANK(G8)=TRUE, "",G8-C8) | K8 | =IF(ISBLANK(H8)=TRUE, "",H8-C8) | L8 | =LOOKUP(D8,{1,2,3,4,5},{"0","3","3","14","30"}) | M8 | =IF(MAX(I8:K8)<=L8,"No","Yes") |
<tbody>
</tbody> |