MOD function: Difference between revisions

From Planfix
Jump to: navigation, search
(Created page with "{{#seo: |title=MOD Function |titlemode=append |keywords=planfix, function, MOD function, reports, MOD |description=ROUND function }} 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 == {| class="wikitable" |- ! style="font-weight: bold" | Formula ! style="font-weight: bold" | Description ! style="font-weight: bold"...")
 
No edit summary
Line 41: Line 41:


== Go To ==
== Go To ==
*[[Standard functions| Formulas]]
*[[Standard functions | Standard operators and Planfix functions]]
*[[Calculated fields]]
*[[Calculated fields]]
*[[Reports]]
*[[Reports]]

Revision as of 11:53, 8 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