On 2002-04-16 11:28, vincenzo wrote:
I need help with a formula that will evaluate whether a number is divisible by 8 (no remainder). If the number in a cell (and it can be any number) is divisible by 8, formula returns Yes, if not, No.
Thanks.
=MOD(A1,8) and custom format the cell containing this formula as...
[=0]"Yes";"No"