0

HI, sorry if this is really thick, but I'm abit stuck...I have written this piece of code as part of a bigger function:

If Z = 1 Then

SIDE = W - (V / 3600#)

End If

If Z = 2 Then

SIDE = W + (V / 3600#)

End If

If Z = 3 Then

SIDE = W - (V / 3600#)

End If

If Z = 4 Then

SIDE = W + (V / 3600#)

End If

If Z = 5 Then

SIDE = W - (V / 3600#)

End If

If Z = 6 Then

SIDE = W + (V / 3600#)

End If

I know it's a stupid way of doing it, but I tried:

If Z = 1 or 3 or 5 Then

SIDE = W - (V / 3600#)

else

SIDE=W + (V / 3600#)

End If

Could someone please help me to find a neater way of telling it to perform different formula for odd and even numbers?

Any help would be much appreciated