Hi All,
I was given a formula that works in excel, but no explanation of how it works. My task is to make it work in openoffice. There is an array in the formula,{1,2}, that I believe is the problem. Knowing how it works would help me tremendously.
The formula looks at a 14 digit number and creates a single digit number from it. 13892001589675 would create 0.
=MOD(SUMPRODUCT(-MID(TEXT(MID(R16,ROW(INDIRECT("1:"&LEN(R16))),1)*(MOD(ROW(INDIRECT("1:"&LEN(R16)))+1,2)+1),"00"),{1,2},1)),10)
Thanks
You could do two separate SPs
=MOD(SUMPRODUCT(-MID(TEXT(MID(R16,ROW(INDIRECT("1:"&LEN(R16))),1)*(MOD(ROW(INDIRECT("1:"&LEN(R16)))+1,2)+1),"00"),1,1))
+SUMPRODUCT(-MID(TEXT(MID(R16,ROW(INDIRECT("1:"&LEN(R16))),1)*(MOD(ROW(INDIRECT("1:"&LEN(R16)))+1,2)+1),"00"),2,1)),10)
Bookmarks