divide

M

Marc

Can any body tell me why when I go to divide with the MOD function it does
not work ?? I am trying to use a1((100)) and divide by 2 . anwser is 50
Does the divide function array work ??? If I try and type in mamual it works
(( =a1/2 it works ????
 
D

Dave Peterson

=mod() doesn't return the quotient, it returns the remainder after the division:

=mod(100,2) returns 0

=100/2 returns 50
 
B

Biff

That's not how MOD works. MOD returns the remainder after a number is
divided by a divisor.

=MOD(100,2) = 0

100 divided by 2 divides evenly so there is no remainder thus MOD(100,2) =
0.

There is no division function. You just use basic math statements:

=100/2

=A1/2

=SUM(A1:A10)/2

Biff
 
Top