Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF( AND( F01="YES", TCV > 25000000 ), 1, 0 ) + ...
- =IF( TCV > 25000000,
- IF(F01="YES",1,0)+IF(F02="YES",1,0)+IF(F03="YES",1,0)+IF(F05="YES",1,0)
- +IF(F06="YES",1,0)+IF(F07="YES",1,0)+IF(F08="YES",1,0)+IF(F09="YES",1,0)
- +IF(F10="YES",1,0)+IF(F11a="YES",1,0)+IF(F12="Yes",1,0)+IF(F13="Yes",1,0)
- +IF(F14="YES",1,0)+IF(F15="YES",1,0)+IF(F16="YES",1,0)+IF(F17="No",1,0)
- +IF(F18="No",1,0)+IF(F20="No",1,0)+IF(F21="Yes",1,0)+IF(F22="YES",1,0)
- , 0)
Add Comment
Please, Sign In to add comment