| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In WORKDAY function, how to exclude multiple/variable holiday rang | Excel Discussion (Misc queries) | |||
| Multiple Variable Formula Help | Excel Worksheet Functions | |||
| Help for multiple & variable validation function | Excel Worksheet Functions | |||
| Passing multiple strings to variable in Replace Function | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Linear Mode
