Check if Equally Divisible

[John]

I want to check if a value is equally divisible by another value and not
sure how to do it

Say I have 6600 in A1 and 250 in B1, what formula could I use to return the
value "No" in C1

 

[Bob Phillips]

=IF(MOD(A1,B1)<>0,"No","Yes")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Domenic]

Try...

=IF(MOD(A1,B1)=0,"Yes","No")

Hope this helps!

 

[Niek Otten]

=IF(MOD(A1,B1)=0,"Yes","No")

 

[John]

Thanks Bob

=IF(MOD(A1,B1)<>0,"No","Yes")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)