MOD function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
 
Line 34: Line 34:
<pre>MOD(<nowiki>{{Task.Worked TO}}-{{Task.Got hired}}</nowiki>;5)</pre>
<pre>MOD(<nowiki>{{Task.Worked TO}}-{{Task.Got hired}}</nowiki>;5)</pre>




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.
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.

Latest revision as of 14:16, 15 February 2024

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.


Go To