# Thread: have formula need explanation

1. ## have formula need explanation

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  Reply With Quote

2. 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)  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•