View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Multiple of a Variable in an If function?

If variable mod 6 = 0 then
'your code
End If

If this post helps click Yes
---------------
Jacob Skaria


"ironhydroxide" wrote:

I am looking to use an IF function and i want the code to do a certain
something if the variable used is a multiple of 6. (i know this is fixable
with fairly simple math, but i havent even thought about algebra for 4years)

i want the code to look something like this
If Variable1 Is (Multiple of 6) then
Code....
Code...
End If

Thanks

ironhydroxid