Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND(E16=200,P17=0),P16*S4,
- IF(AND(E16=200,P17>0),P16*N4,
- IF(AND(E16=1,P17=0),P16*S2,
- IF(AND(E16=1,P17>0),P16*H2,
- IF(E16=3,SUM(Q16:U16),
- )))))
- ...
- IF(AND(E16=1,P17>0),P16*H2,
- IF(E16=3,SUM(Q16:U16),"No value found, error"
- )))))
Add Comment
Please, Sign In to add comment