Results 1 to 2 of 2

Thread: have formula need explanation

  1. #1

    have formula need explanation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #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)

Posting Permissions

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