Ask Your Question

# 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

## 2 Answers

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

## Comments

For MOD as calc function look here.

( 2018-06-07 06:45:29 +0200 )edit

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: 121 times

Last updated: Aug 16 '16