Can you provide a more thorough explanation of the problem you're trying to solve? Can you also give some idea of the structure of your data?
Could you please more about "looping" you are talking about?
If you want to check for even number , then you can try below logic:
Check = [Number] % 2
Check will return 0 for even numbers and <>0 for odd.