divisible if statements

Is there a way to form an IF statement that checks whether two cells are divisible in a general term.

Example: if(X is divisible by Z, then True,False) or if 1000 is divisible by 100 then, T,F.

Something like this perhaps?

=LEFT(INT(A1/B1) = A1/B1)

THX,

That helps.

Or

Please Login or Register  to view this content.

ChemistB

thanks. I acheived the goal and got a good result.