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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" <r.@9999yahoo.co.uk> wrote in message
news:e0lsbg$gmf$1@reader01.news.esat.net...
> 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
>
>

Thanks Bob

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:usx88xYVGHA.4248@TK2MSFTNGP10.phx.gbl...
> =IF(MOD(A1,B1)<>0,"No","Yes")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "John" <r.@9999yahoo.co.uk> wrote in message
> news:e0lsbg$gmf$1@reader01.news.esat.net...
>> 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
>>
>>
>
>

Try...

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

Hope this helps!

In article <e0lsbg$gmf$1@reader01.news.esat.net>,
"John" <r.@9999yahoo.co.uk> 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

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

--
Kind regards,

Niek Otten

"John" <r.@9999yahoo.co.uk> wrote in message news:e0lsbg$gmf$1@reader01.news.esat.net...
>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
>