how to find the gcd of two numbers in ms excel 2000

  • Thread starter Thread starter blcarmadillo
  • Start date Start date
B

blcarmadillo

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.
 
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("1:"&A1)))=0,IF(MOD(B1,ROW(INDIRECT("1:"&A1)))=0,ROW(INDIRECT("1:"&A1)))))

confirmed with CTRL+SHIFT+ENTER
 
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: > =MAX(IF(MOD(A1,ROW(INDIRECT("1:"&A1)))=0,IF(MOD(B1
,ROW(INDIRECT("1:"&A1)))=0,ROW(INDIRECT("1:"&A1))) )) I'm using fields C2 and D2 though so I replaced all the A1 attributes
Click to expand...
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.
 
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
 
Back
Top