Guest User

Untitled

a guest
Jul 23rd, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. =IF( AND( F01="YES", TCV > 25000000 ), 1, 0 ) + ...
  2.  
  3. =IF( TCV > 25000000,
  4. IF(F01="YES",1,0)+IF(F02="YES",1,0)+IF(F03="YES",1,0)+IF(F05="YES",1,0)
  5. +IF(F06="YES",1,0)+IF(F07="YES",1,0)+IF(F08="YES",1,0)+IF(F09="YES",1,0)
  6. +IF(F10="YES",1,0)+IF(F11a="YES",1,0)+IF(F12="Yes",1,0)+IF(F13="Yes",1,0)
  7. +IF(F14="YES",1,0)+IF(F15="YES",1,0)+IF(F16="YES",1,0)+IF(F17="No",1,0)
  8. +IF(F18="No",1,0)+IF(F20="No",1,0)+IF(F21="Yes",1,0)+IF(F22="YES",1,0)
  9. , 0)
Add Comment
Please, Sign In to add comment