Advertisement
Guest User

Untitled

a guest
Dec 20th, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. if (x < 0, x + 1, x)
  2.  
  3. if ((A1 + B1) < 0, (A1 + B1) + 1, (A1 + B1))
  4.  
  5. x = (A1 + B1);
  6. if (x < 0, x + 1, x);
  7.  
  8. if(
  9. timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
  10. < 0,
  11. 1 +
  12. timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
  13. ,
  14. timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
  15. )
  16.  
  17. x = timevalue(Sheet1!$D10) - timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))));
  18. if(
  19. x
  20. < 0,
  21. 1 +
  22. x
  23. ,
  24. x
  25. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement