is 3 a factor?

[MikeL]

Hi, I am using XL 2000.

I have a value in cell A1. In cell B1, I am trying to write a formula to determine if "3" is a factor of the value in cell A1. What could that formula be?

I was thinking of: If(A1/3."yes","no"), but I cant seem to put the correct equation after the division.

Thanks in advance.

 

[kskinne]

the formula:
=MOD(A1,3)=0

will return TRUE if the value in cell A1 is evenly divided by 3, otherwise FALSE

hth
kevin

 

[IML]

Perhaps something along the lines of
=IF(MOD(A1,3),"no","Yes")?

 

[Barry Katcher]

You can use this in B1:

=IF(MOD(A1,3)=0,"yes","no")

 

[Barry Katcher]

I just noticed that the MOD formula only works if the number in A1 is a whole number. See my second set of samples below for a formula that works on decimals also.

New Book.xls
	A	B	C	D
1	3	yes	=IF(MOD(A1,3)=0,"yes","no")
2	3.33	no
3	4	no
4	6	yes
5
6	3	yes	=IF(GCD(A6,3)=3,"yes","no")
7	3.33	yes
8	4	no
9	6	yes
Sheet1

 

[texasalynn]

What is the GCD? Is that a new function? It is not in Office 97. What does it do?

thanks. . .texasalynn

 

[Barry Katcher]

I don't think GCD is part of an add-in, like MoreFunc. I'm using Excel 2000 and I believe it's part of the standard Math/Trig functions.

But I just found the GCD doesn't work in all situations. For example, on 6.664, it returns a "yes", which is incorrect, since 3 doesn't go into 6.664 evenly. Still working on it.

 

[Dave Patton]

per HELP

Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

f any value is not an integer, it is truncated.

 

[texasalynn]

I just had to click to turn on the Analysis Pack in the add-ins. Now I have GCD as a function.

Thanks . . . texasalynn

 

[shades]

per HELP

Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.

If any value is not an integer, it is truncated.

That is because in mathematics "mod" (from number theory - and so too, GCD) only deals with integers. So while in simple division, 3 divides "evenly" (w/o a remainder) into 6.6666, in number theory it is a non issue, so to speak.