Hi, I was wondering if anyone knows how to find the greatest common
denominator (gcd) of two numbers in microsoft excel 2000. Thanks for
any help.--
blcarmadillo
------------------------------------------------------------------------
blcarmadillo's Profile: www.excelforum.com/member.php...oamp;userid=32841
View this thread: www.excelforum.com/showthread...hreadid=526344
=GCD(B8, B17)
Give this a try--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=526344
You can use GCD function which is part of Analysis ToolPak addin,
otherwise this formula will give you the greatest common denominator of
two integers in A1 and B1
=MAX(IF(MOD(A1,ROW(INDIRECT(quot;1:quot;amp;A1)))=0,IF(MOD(B1 ,ROW(INDIRECT(quot;1:quot;amp;A1)))=0,ROW(INDIRECT(quot;1:quot;amp;A1))) ))
confirmed with CTRL SHIFT ENTER--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526344
Thanks davesexcel and daddylonglegs for the reply. I really would like
to have it so that anyone can use my spreadsheet without having to load
add-ons so I think the best bet would be to try using some formula. I
tried using the formula daddylonglegs posted: gt; =MAX(IF(MOD(A1,ROW(INDIRECT(quot;1:quot;amp;A1)))=0,IF(MOD(B1
gt; ,ROW(INDIRECT(quot;1:quot;amp;A1)))=0,ROW(INDIRECT(quot;1:quot;amp;A1))) )) I'm using fields C2 and D2 though so I replaced all the A1 attributes
with an attribute of C2 and the B1 attribute with the attribute D2. In
cell C2 I had the value: 4; and in D2 I had the value: 12. Therefore, I
should have gotten an answer of: 4; however, I got an answer of 1. An
help is greatly appreciated. Thanks.--
blcarmadillo
------------------------------------------------------------------------
blcarmadillo's Profile: www.excelforum.com/member.php...oamp;userid=32841
View this thread: www.excelforum.com/showthread...hreadid=526344
Hi, it's the correct formula but you need to confirm it with
CTRL SHIFT ENTER.
If you have the formula already on your sheet select that cell then
press F2 then while holding down CTRL SHIFT buttons press ENTER. Curly
braces like { should appear around your formula and you should get the
correct result--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526344
Alright. Thanks daddylonglegs for the reply. Sorry that I skipped that
step.--
blcarmadillo
------------------------------------------------------------------------
blcarmadillo's Profile: www.excelforum.com/member.php...oamp;userid=32841
View this thread: www.excelforum.com/showthread...hreadid=526344
- Aug 28 Tue 2007 20:39
how to find the gcd of two numbers in ms excel 2000
close
全站熱搜
留言列表
發表留言