MOD function with negative numbers
roger32909 at bellsouth.net
roger32909 at bellsouth.net
Wed Mar 1 15:35:48 CST 2006
If I use the mod function in Excel, say =mod(-1,7), the result is 6.
If I google "-1 modulo 7", the result is 6.
But if I use the PH mod function for MOD(-1,7) the result is -1
$ QUIZ
Q U I Z (7.10.G1)
Copyright 1998 COGNOS INC. (ALPHA)
Licensed PH-AXP-RUNTIME
> DEFINE D-1 = MOD(1,7)
> DEFINE D-2 = MOD(2,7)
> DEFINE D-3 = MOD(3,7)
> DEFINE D-4 = MOD(4,7)
> DEFINE D-5 = MOD(5,7)
> DEFINE D-6 = MOD(6,7)
> DEFINE D-7 = MOD(7,7)
> DEFINE D-1N = MOD(-1,7)
> DEFINE D-2N = MOD(-2,7)
> DEFINE D-3N = MOD(-3,7)
> DEFINE D-4N = MOD(-4,7)
> DEFINE D-5N = MOD(-5,7)
> DEFINE D-6N = MOD(-6,7)
> DEFINE D-7N = MOD(-7,7)
> SAVE TEST-MOD
> REPO ALL
> GO
03/01/06 System PAGE 1
D-1 D-2 D-3 D-4 D-5 D-6 D-7 D-1N
D-2N D-3N D-4N D-5N D-6N D-7N
1 2 3 4 5 6 0 -1
-2 -3 -4 -5 -6 0
Are there two different modular arithmetic systems for negative numbers? Or am I doing something wrong?
More information about the powerh-l
mailing list