MOD Function

[Stubby]

Hi fellow excel users!

I have a data list that has a column (called record) of sequential numbers. I needed to filter the list so that I see all the records whose record number was divisible by 5. A colleague suggested the following formula in the criteria row of an advanced filter would work:

=MOD(A7,5)=0

This does work, however I don't know why!! I understand that the MOD function takes a value and divides by the divisor (in this instance 5) and leaves a remainder but I'm at a loss as to what the =0 bit does.

Many thanks in advance for any help!

 

[VoG]

That says if A7 is exactly divisible by 5.

 

[Stubby]

Many thanks VoG - thats got to be the quickest answer I have ever had using this site!

 

[Rick Rothstein]

Hi fellow excel users!

I have a data list that has a column (called record) of sequential numbers. I needed to filter the list so that I see all the records whose record number was divisible by 5. A colleague suggested the following formula in the criteria row of an advanced filter would work:

=MOD(A7,5)=0

This does work, however I don't know why!! I understand that the MOD function takes a value and divides by the divisor (in this instance 5) and leaves a remainder but I'm at a loss as to what the =0 bit does.

Since the MOD function returns the remainder after dividing the first argument by the second argument, that formula is testing if the remainder is 0... if it is, that must mean the second argument divided the first argument exactly (there was no remainder).