API tools faq
paste
Advertisement
Guest User

Sharepoint

a guest
Dec 13th, 2017
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.77 KB | None | 0 0
raw download clone embed print report
  1. =IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 1");"Option 1";
  2. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 2");"Option 2";
  3. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  4. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 1");"Option 2";
  5. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 2");"Option 2";
  6. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  7. ""))))))&
  8. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  9. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  10. IF(AND([Column 1]="Option 1";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  11. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 1");"Option 2";
  12. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 2");"Option 2";
  13. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  14. ""))))))&
  15. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 1");"Option 2";
  16. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 2");"Option 2";
  17. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  18. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  19. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  20. IF(AND([Column 1]="Option 1";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  21. ""))))))&
  22. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 1");"Option 3";
  23. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 2");"Option 3";
  24. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  25. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 1");"Option 3";
  26. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 2");"Option 3";
  27. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  28. ""))))))&
  29. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  30. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  31. IF(AND([Column 1]="Option 1";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  32. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 1");"Option 2";
  33. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 2");"Option 2";
  34. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  35. ""))))))&
  36. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 1");"Option 2";
  37. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 2");"Option 2";
  38. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  39. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  40. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  41. IF(AND([Column 1]="Option 2";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  42. ""))))))&
  43. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 1");"Option 2";
  44. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 2");"Option 2";
  45. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  46. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 1");"Option 2";
  47. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 2");"Option 2";
  48. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  49. ""))))))&
  50. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  51. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  52. IF(AND([Column 1]="Option 2";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  53. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 1");"Option 3";
  54. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 2");"Option 3";
  55. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  56. ""))))))&
  57. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 1");"Option 3";
  58. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 2");"Option 3";
  59. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  60. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  61. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  62. IF(AND([Column 1]="Option 2";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  63. ""))))))&
  64. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 1");"Option 3";
  65. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 2");"Option 3";
  66. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  67. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 1");"Option 3";
  68. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 2");"Option 3";
  69. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  70. ""))))))&
  71. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  72. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  73. IF(AND([Column 1]="Option 3";[Column 2]="Option 1";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  74. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 1");"Option 3";
  75. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 2");"Option 3";
  76. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  77. ""))))))&
  78. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 1");"Option 3";
  79. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 2");"Option 3";
  80. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  81. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  82. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  83. IF(AND([Column 1]="Option 3";[Column 2]="Option 2";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  84. ""))))))&
  85. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 1");"Option 3";
  86. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 2");"Option 3";
  87. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 1";[Column 4]="Option 3");"Option 3";
  88. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 1");"Option 3";
  89. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 2");"Option 3";
  90. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 2";[Column 4]="Option 3");"Option 3";
  91. ""))))))&
  92. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 1");"Option 3";
  93. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 2");"Option 3";
  94. IF(AND([Column 1]="Option 3";[Column 2]="Option 3";[Column 3]="Option 3";[Column 4]="Option 3");"Option 3";
  95. "")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!