www.dtptools.com
PRODUCTS HELP SUPPORT CONTACTS STORE ABOUT

host logoInDesign/InCopy

host logoiOS

host logoOnline Services

MOD

MOD rturns the remainder after number is divided by divisor. The result has the same sign as divisor.

Syntax

MOD(number,divisor)

 
1
2
3
4
5
AB
FormulaDescription (Result)
=MOD(3, 2)Remainder of 3/2 (1)
=MOD(-3, 2)Remainder of -3/2. The sign is the same as divisor (1)
=MOD(3, -2)Remainder of 3/-2. The sign is the same as divisor (-1)
=MOD(-3, -2)Remainder of -3/-2. The sign is the same as divisor (-1)
     
© 2004 - 2021 DTP Tools Ltd. All rights reserved. Legal Notices. Disclaimer.