I have not got time to work it out for you, but you could extract the last 2 digits from the number and see if that will divide by 2. That should determine if it is odd or even. You need to take the 2 incase of it being a ten multiple, or you could say if the last one is zero it must be even. YOu might need to bring the INT (integer) function into use to get the answer.
Hope that gives you somethig to think about.