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.


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    You could do two separate SPs


Posting Permissions

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