Check if Equally Divisible
 

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

Check if Equally Divisible
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
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

Check if Equally Divisible
 

Try...

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

Hope this helps!

In article ,
"John" wrote:

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

Check if Equally Divisible
 

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

--
Kind regards,

Niek Otten

"John" wrote in message ...
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

Check if Equally Divisible
 

Thanks Bob

"Bob Phillips" wrote in message
...
=IF(MOD(A1,B1)<0,"No","Yes")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
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