Hello there,

I would like to use a function that will tell me if a
number is divisable by another without any remainders.

I've had a look at the various functions and can't seem to
find a relevant one.

If anyone has any ideas that would be great!

Thank you in advance

Judith

Hi,
If A1=456,B1=12,then
if C1=mod(A1,B1) is zoro,then A1is divisible by B1.If C1 is 6,the remainder
will be 6 and that A1 is not divisible by B1.
Thank you,
K.S.Warrier

"JudithJubilee" wrote:

Hello there,

I would like to use a function that will tell me if a
number is divisable by another without any remainders.

I've had a look at the various functions and can't seem to
find a relevant one.

If anyone has any ideas that would be great!

Thank you in advance

Judith

Another way

=INT(A1/B1)=A1/B1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"K.S.Warrier" wrote in message
...
Hi,
If A1=456,B1=12,then
if C1=mod(A1,B1) is zoro,then A1is divisible by B1.If C1 is 6,the
remainder
will be 6 and that A1 is not divisible by B1.
Thank you,
K.S.Warrier

"JudithJubilee" wrote:

Hello there,

I would like to use a function that will tell me if a
number is divisable by another without any remainders.

I've had a look at the various functions and can't seem to
find a relevant one.

If anyone has any ideas that would be great!

Thank you in advance

Judith

=MOD(number,divisor)=0

HTH,
Bernd