Advanced Search

jevans95

0 Reputation

0 Badges

18 years, 120 days
Contact jevans95

MaplePrimes Activity


These are replies submitted by jevans95

Help me explain...

jevans95 0
February 21 2008
0 0

 

=MATCH(1,INDEX(MOD(ROW(INDIRECT("1:"&A1))*B1,A1),0),0))

I used this command for a project that required me to program the Chinese Remainder Theorem into Excel. My professor then asked me how this works. Of course, I was not exactly sure. Could you please give me an explanation of the commands and how the function works?

Help me explain...

jevans95 0
February 21 2008

 

=MATCH(1,INDEX(MOD(ROW(INDIRECT("1:"&A1))*B1,A1),0),0))

I used this command for a project that required me to program the Chinese Remainder Theorem into Excel. My professor then asked me how this works. Of course, I was not exactly sure. Could you please give me an explanation of the commands and how the function works?

Page 1 of 1