Thanks for your reply. Much appreciated.
For some reason, it doesn't work...here is what I get using both formulas provided above: - use C1, instead of A1 to show the formula.
3 6 9 12 15 18 21 24
=MOD(C1,4)<>C1 FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
=IF(MOD(C1,4)<>C1,"yes","no") no yes yes yes yes yes yes yes

If it were true, then for the range of numbers from 12-15, it should be "FALSE" or "no" as that range only contains 13, 14, 15.

Thank you.