Ask Your Question
0

On Subr time, what does =MOD do?

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

abi gravatar image

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

Thanks!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2016-08-15 14:40:10 +0200

mark_t gravatar image

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

edit flag offensive delete link more

Comments

For MOD as calc function look here.

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-07 06:45:29 +0200 )edit
0

answered 2016-08-16 02:41:02 +0200

Lupp gravatar image

updated 2016-08-16 02:46:56 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 56 times

Last updated: Aug 16 '16