I am trying to write an IF formula to say €œIf the value in A1 is divisible by
7 and the result is an integer (that is no decimal reminder like 14, 21, 28)
then divide A1 by 7 otherwise put X€�. How do I write this formula please?
Thanks.