protonLeah, thank you for your reply. I have tried your formula and an error comes up saying - A value used in the formula is of the wrong data type?

bebo021999 - if they are both divisible by two, that's fine, I am only struggling for this formula if none of them are divisible by 2.

Thank you.