On Subr time, what does =MOD do?

Why =mod((b1-a1),1) . Where would I find INFO, on =Mod?

Thanks!

edit retag close merge delete

Sort by » oldest newest most voted The MOD function calculates the remainder of the division.

You can use the insert, function wizard to see the available worksheet functions with brief descriptions, or refer to https://help.libreoffice.org/Calc/Fun....

If you are looking for functions used in BASIC macros then refer to https://help.libreoffice.org/Basic/Ru....

more

If we allow for arbitrary real numbers as arguments of MOD (the second one <>0), there is the mathematical equivalence MOD(a,b) = a - INT(a / b) * b (for b <> 0). The evaluation done by MOD should be more efficient, however.
Both the arguments being natural numbers, MOD will return the ordinary remainder of the division.

(INT(x) = g if g - 1 < x <= g which is the case for exactly one integer number g if x is a real number.)

more

Stats

Asked: 2016-08-15 13:57:00 +0200

Seen: 56 times

Last updated: Aug 16 '16