how to use the divisibility condition in excel with 'if' statemen.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to use the divisibility condition in excel with the 'if' statement?
 
mani said:
how to use the divisibility condition in excel with the 'if' statement?
Click to expand...

Do you mean something like

If x Mod y = 0 Then Debug.Print x & " is a multiple of " & y

?
 
You must log in or register to reply here.

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

Similar Threads

How to use IfError in Excel 2007 VBA ? 4
Speed up calcs within macro.... 7
If Condition 4
Multiple Criteria for worksheet 3
check if a cell contains a number, not text 2
How to read xml file using VBA macro 1
Count unique values - Match and conditional IF 2
formula using Divisibility test 1

Back
Top