Ok so I am trying to write a If statement that if a variable is an odd number then it will use one formulae and if it is an even number it will use a different one.
I tried using
[VBA]
If variable Is Odd Then
'formula 1
Else
'formula2
End If
[/VBA]
however Odd/Even aren't useable criteria, do you guys know how I could solve this or if there is something i could use instead of odd?