Check if Equally Divisible

J

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top