How come the Mod operator can return negative values? I've always
wondered why.

well, what is there to wonder in that.
-3 Mod 2 will return -1
and that is perfect

- manges

--
Message posted from http://www.ExcelForum.com

mangesh_yadav < wrote:
well, what is there to wonder in that.
-3 Mod 2 will return -1
and that is perfect

- mangesh


---
Message posted from http://www.ExcelForum.com/

Is that standard in all major programming languages?


mangesh_yadav < wrote:
well, what is there to wonder in that.
-3 Mod 2 will return -1
and that is perfect

- mangesh


---
Message posted from http://www.ExcelForum.com/

It has to be.

- Manges

--
Message posted from http://www.ExcelForum.com

You seem to be getting into the universal definition paradigm. VBA defines
how the MOD operator works. Excel has a MOD function and it works
differently - but its operation is defined in help. Mathematics may have
another definition of how MOD works or rather what modulus/modulo is. You
can't assume that a programming function will work the way your math teacher
defined a math operation. You have to look at the documentation.

as an illustrative point, one would think that addition would be pretty
straightforward, but then you run into limitations in the IEEE
implementation of a double . . .

Each language that has a standard defines their own implementation. Those
that don't have a recognized standard define it in their documentation.
There is no universal standard (that I am aware of) that you seem to imply.

http://support.microsoft.com/default...78&Product=xlw
MOD Function and Mod Operator Return Different Values

http://support.microsoft.com/default...71&Product=xlw
XL2000: MOD Function and Mod Operator Return Different Values

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
Is that standard in all major programming languages?


mangesh_yadav < wrote:
well, what is there to wonder in that.
-3 Mod 2 will return -1
and that is perfect

- mangesh


---
Message posted from http://www.ExcelForum.com/

Ok. Point taken. Thanks, Tom.

Tom Ogilvy wrote:

You seem to be getting into the universal definition paradigm. VBA defines
how the MOD operator works. Excel has a MOD function and it works
differently - but its operation is defined in help. Mathematics may have
another definition of how MOD works or rather what modulus/modulo is. You
can't assume that a programming function will work the way your math teacher
defined a math operation. You have to look at the documentation.

as an illustrative point, one would think that addition would be pretty
straightforward, but then you run into limitations in the IEEE
implementation of a double . . .

Each language that has a standard defines their own implementation. Those
that don't have a recognized standard define it in their documentation.
There is no universal standard (that I am aware of) that you seem to imply.

http://support.microsoft.com/default...78&Product=xlw
MOD Function and Mod Operator Return Different Values

http://support.microsoft.com/default...71&Product=xlw
XL2000: MOD Function and Mod Operator Return Different Values

Some implementations of MOD work differently when the arguments have different
signs. The worksheet function uses the definition that the modulus is always
positive, i.e. =MOD(-10,3) yields -4 with a remainder of 2. OTOH, in VBA,
definition that's used is probably what you division in grade school: -10
divided by +3 is -3 with a remainder of -1.


On Wed, 01 Sep 2004 10:08:40 -0400, R Avery wrote:

How come the Mod operator can return negative values? I've always
wondered why.