Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND($R2<>0,$S2<=0,$T2<=0),"Lost
- "&$S$1,IF(AND($Q2<>0,$R2<=0,$S2<=0),"Lost
- "&$R$1,IF(AND($P2<>0,$Q2<=0,$R2<=0),"Lost
- "&$Q$1,IF(AND($O2<>0,$P2<=0,$Q2<=0),"Lost
- "&$P$1,IF(AND($N2<>0,$O2<=0,$P2<=0),"Lost
- "&$O$1,IF(AND($M2<>0,$N2<=0,$O2<=0),"Lost
- "&$N$1,IF(AND($L2<>0,$M2<=0,$N2<=0),"Lost
- "&$M$1,IF(AND($K2<>0,$L2<=0,$M2<=0),"Lost
- "&$L$1,IF(AND($J2<>0,$K2<=0,$L2<=0),"Lost
- "&$K$1,IF(AND($I2<>0,$J2<=0,$K2<=0),"Lost
- "&$J$1,IF(AND($H2<>0,$I2<=0,$J2<=0),"Lost
- "&$I$1,IF(AND($G2<>0,$H2<=0,$I2<=0),"Lost
- "&$H$1,IF(AND($F2<>0,$G2<=0,$H2<=0),"Lost
- "&$G$1,IF(AND(,$F2<=0,$G2<=0),"Lost
- "&$F$1,IF(AND($F2<=0),
- "")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement