MOD function
From Planfix
The function returns the remainder of the argument "number" divided by the value of the argument "divisor". The result has the same sign as the divisor.
Format
MOD(number; divisor)
Examples
| Formula | Description | Result |
|---|---|---|
| MOD(3; 2) | Remainder of 3/2 division | 1 |
| MOD(-3; 2) | Remainder of -3/2 division. The sign is the same as the divisor. | 1 |
| MOD(3; -2) | Remainder of 3/-2 division. The sign is the same as the divisor. | -1 |
MOD({{Task.Worked TO}}-{{Task.Got hired}};5)
We divide by 5 to find the date of the employee's anniversary in the company. If the employee has a working anniversary in the company, we get 0 as an answer.