Guest User

full2

a guest
Jan 13th, 2020
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. =IF(
  2.  
  3. OR(
  4. E1<>E2,
  5.  
  6. E2=1,
  7.  
  8. (ROW()>3)
  9. *(OFFSET($A$1,(ROW()-1)-1,COLUMN()-1)="")
  10. *(E2=2),
  11.  
  12. (ROW()>4)
  13. *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
  14. OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
  15. *(E2=3),
  16.  
  17. (ROW()>5)
  18. *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
  19. IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
  20. OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
  21. *(E2=4),
  22.  
  23. (ROW()>6)
  24. *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-4,COLUMN()-1),""),
  25. IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
  26. IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
  27. OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
  28. *(E2=5)
  29.  
  30. (ROW()>7)
  31. *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-5,COLUMN()-1),""),
  32. IFERROR(OFFSET($A$1,(ROW()-1)-4,COLUMN()-1),""),
  33. IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
  34. IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
  35. OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
  36. *(E2=6)
  37.  
  38. ),
  39.  
  40. IF(
  41. E2=1,
  42. IF(V2="W",98*T2-98,-100),
  43.  
  44. IF(
  45. E2=2,
  46. IF(OR(V2="W",V3="W"),(((1/T2)/(1/T2+1/T3)*98)*T2)-98,-100),
  47.  
  48. IF(
  49. E2=3,
  50. IF(OR(V2="W",V3="W",V4="W"),(((1/T2)/(1/T2+1/T3+1/T4)*98)*T2)-98,-100),
  51.  
  52. IF(
  53. E2=4,
  54. IF(OR(V2="W",V3="W",V4="W",V5="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5)*98)*T2)-98,-100),
  55.  
  56. IF(
  57. E2=5,
  58. IF(OR(V2="W",V3="W",V4="W",V5="W",v6="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5+1/T6)*98)*T2)-98,-100),
  59.  
  60. IF(
  61. E2=6,
  62. IF(OR(V2="W",V3="W",V4=“W”,V5=“W",V6="W", V7="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5+1/T6+1/T7)*98)*T2)-98,-100),
  63.  
  64. ""
  65. )
  66. )
  67.  
  68. )
  69.  
  70. )
  71.  
  72. )
  73.  
  74. ),
  75.  
  76. ""
  77.  
  78. )
Add Comment
Please, Sign In to add comment