Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (x < 0, x + 1, x)
- if ((A1 + B1) < 0, (A1 + B1) + 1, (A1 + B1))
- x = (A1 + B1);
- if (x < 0, x + 1, x);
- if(
- timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
- < 0,
- 1 +
- timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
- ,
- timevalue(Sheet1!$D10)-timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))))
- )
- x = timevalue(Sheet1!$D10) - timevalue(min(filter(Sheet1!$D$2:$D$99,Sheet1!$A$2:$A$99=A10,Sheet1!$E$2:$E$99=E10))));
- if(
- x
- < 0,
- 1 +
- x
- ,
- x
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement