REMAINDER这函数第一次用,学习了
REMAINDER returns the remainder of the 1st argument divided by the 2nd argument.
Remainder is similar to MOD except thaqt REMAINDER uses ROUND in its calculations, whereas MOD uses FLOOR
rem和mod一样??
???remainder是If n1 != 0, then the remainder is n2 - (n1*N) where N is the integer nearest n2/n1.
If n2/n1 equals x.5, then N is the nearest even integer.
8-(3*3)=-1
helonten 发表于 2013-10-28 09:47
MOD的算法好像是MOD(A,B) = A - B*FLOOR(A/B);
REMAINDER算法是REMAINDER(A,B) = A-B*ROUND(A/B);
还基本真是,除了round为.5的时候到两端距离一样,所以规定出了一个值
If n1 != 0, then the remainder is n2 - (n1*N) where N is the integer nearest n2/n1.
If n2/n1 equals x.5, then N is the nearest even integer.