Is there a formula to tell me if one number is a multiple of another number?

M

Marvin Hlavac

Is there a formula that will tell me if a number can be divided by another
number?
For example in A1 I will enter number 24 and in B1 number 6. In C1 I would
like it to return TRUE because I can divide those two numbers.
 
D

Dale Hymel

All numbers can be divided by any other number expect 0. But if you mean,
one is a factor of the other then

=if(a1/b1=int(a1/b1),True,False)
 
M

Marvin Hlavac

Dale & Vasant,

Thank you both very much!!!

Both formulas:

=if(a1/b1=int(a1/b1),True,False)

and

=MOD(A1,B1)=0

do exactly what I needed. From the moment I posted my question it took you 8
and 11 minutes to solve something I spent hours today unsuccessfully trying
to solve myself...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top