Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. =IF(AND($R2<>0,$S2<=0,$T2<=0),"Lost
  2. "&$S$1,IF(AND($Q2<>0,$R2<=0,$S2<=0),"Lost
  3. "&$R$1,IF(AND($P2<>0,$Q2<=0,$R2<=0),"Lost
  4. "&$Q$1,IF(AND($O2<>0,$P2<=0,$Q2<=0),"Lost
  5. "&$P$1,IF(AND($N2<>0,$O2<=0,$P2<=0),"Lost
  6. "&$O$1,IF(AND($M2<>0,$N2<=0,$O2<=0),"Lost
  7. "&$N$1,IF(AND($L2<>0,$M2<=0,$N2<=0),"Lost
  8. "&$M$1,IF(AND($K2<>0,$L2<=0,$M2<=0),"Lost
  9. "&$L$1,IF(AND($J2<>0,$K2<=0,$L2<=0),"Lost
  10. "&$K$1,IF(AND($I2<>0,$J2<=0,$K2<=0),"Lost
  11. "&$J$1,IF(AND($H2<>0,$I2<=0,$J2<=0),"Lost
  12. "&$I$1,IF(AND($G2<>0,$H2<=0,$I2<=0),"Lost
  13. "&$H$1,IF(AND($F2<>0,$G2<=0,$H2<=0),"Lost
  14. "&$G$1,IF(AND(,$F2<=0,$G2<=0),"Lost
  15. "&$F$1,IF(AND($F2<=0),
  16. "")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement