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

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
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.
 
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)
 
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...
 
Back
Top