# On Subr time, what does =MOD do?

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

Thanks!

First time here? Check out the FAQ!

On Subr time, what does =MOD do?

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

Thanks!

add a comment

1

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

0

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

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

Seen: **121 times**

Last updated: **Aug 16 '16**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.