evaluate division

[vincenzo]

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.

 

[Yogi Anand]

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")

 

[Jay Petrulis]

Hi,

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

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

HTH,
Jay

 

[vincenzo]

That's it. Thanks very much!

 

[Mark W.]

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

or

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

[=0]"Yes";"No"

 

[Yogi Anand]

=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!