Ask Your Question

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?


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

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

If you are looking for functions used in BASIC macros then refer to

edit flag offensive delete link more


For MOD as calc function look here.

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

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


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

Seen: 121 times

Last updated: Aug 16 '16