Guest User

Untitled

a guest
Oct 18th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. =IF(AND(E16=200,P17=0),P16*S4,
  2. IF(AND(E16=200,P17>0),P16*N4,
  3. IF(AND(E16=1,P17=0),P16*S2,
  4. IF(AND(E16=1,P17>0),P16*H2,
  5. IF(E16=3,SUM(Q16:U16),
  6. )))))
  7.  
  8. ...
  9. IF(AND(E16=1,P17>0),P16*H2,
  10. IF(E16=3,SUM(Q16:U16),"No value found, error"
  11. )))))
Add Comment
Please, Sign In to add comment