Multiple of a Variable in an If function?
 

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

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

Multiple of a Variable in an If function?
 

You are amazing!!

"Jacob Skaria" wrote:

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

Multiple of a Variable in an If function?
 

Function MultOfSix(x) As Boolean

MultOfSix = x / 6 = Int(x / 6)

End Function


To use:

If MultOfSix(yourVar) then
'your code
Else
'not multiple of six
End If

--
Steve

"ironhydroxide" wrote in message
...
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