Thanks:  0
Likes:  0

1. 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.

2. 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.
One of the ways would be to use the MOD FUNCTION

=IF(MOD(A2,8),"not divisible by 8","divisible by 8")

3. Hi,

Use the MOD function. If the test cell is A1, then try:

=IF(MOD(A1,8)=0,"Yes","No")

HTH,
Jay

4. That's it. Thanks very much!

5. =IF(MOD(A1,8),"No","Yes")

or

=MOD(A1,8) and custom format the cell containing this formula as...

[=0]"Yes";"No"

6. =MOD(A1,8) and custom format the cell containing this formula as...

[=0]"Yes";"No"
Hi Mark:
That's a beauty ... really ingenious use and practical!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•