Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. =IF(P11="";"";IF(OR(P$9="MO";P$9="TU";P$9="WE";P$9="TH";P$9="FR");IF(P11<=8;P11*$K$37*($C11+$D11+$E11);8*($K$37)*$C11+IF(MAX(0;P11-8)-MAX(0;P11-10)<0;0;((MAX(0;P11-8))-(MAX(0;P11-10)))*$K$15*($C11+$D11+$E11)*(1+Data!$U$2))+IF((MAX(0;P11-8)-2)<=0;0;(MAX(0;P11-8)-2)*$K$37*($C11+$D11+$E11)*(1+Data!$V$2)));IF(P$9="SA";IF(P11<=8;P11*$K$37*($C11+$D11+$E11)*(1+Data!$T$3);8*$K$37*$C11*(1+Data!$T$3)+IF((P11-8)<0;0;(P11-8)*$K$37*$C11*(1+Data!$U$3)));IF(P$9="SU";IF(COUNTA($E11:$O11)=6;P11*($K$15*$C11*(1+Data!$W$3));P11*($K$37*$C11*(1+Data!$V$3)));""))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement