+ Reply to Thread
Results 1 to 3 of 3

decoding formula assistance

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    LA, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    decoding formula assistance

    Can somebody break down the below formula in layman's terms please? I need to provide instructions on how to build this, but I don't understand it.

    =MOD(10-MOD(SUM(2*(CODE(MID(B2,1,1))-48)-9*INT((CODE(MID(B2,1,1))-48)/5),CODE(MID(B2,2,1))-48,2*(CODE(MID(B2,3,1))-48)-9*INT((CODE(MID(B2,3,1))-48)/5),CODE(MID(B2,4,1))-48,2*(CODE(MID(B2,5,1))-48)-9*INT((CODE(MID(B2,5,1))-48)/5),CODE(MID(B2,6,1))-48,2*(CODE(MID(B2,7,1))-48)-9*INT((CODE(MID(B2,7,1))-48)/5),CODE(MID(C2,1,1))-48,2*(CODE(MID(C2,2,1))-48)-9*INT((CODE(MID(C2,2,1))-48)/5),CODE(MID(C2,3,1))-48,2*(CODE(MID(D2,1,1))-48)-9*INT((CODE(MID(D2,1,1))-48)/5),CODE(MID(E2,1,1))-48,2*(CODE(MID(E2,2,1))-48)-9*INT((CODE(MID(E2,2,1))-48)/5)),10),10)

    Thank you!
    Attached Files Attached Files
    Last edited by eehimes; 07-31-2014 at 01:43 PM. Reason: adding attachment

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: decoding formula assistance

    It would help considerably if there was a file attached so we at least had some breadcrumbs to follow why you're even using it.

    The references don't mean much otherwise.

    That said, it's just going to take a highlighting the nested expressions and hitting F9 to see what it's doing.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    07-31-2014
    Location
    LA, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: decoding formula assistance

    Thanks, daffodil11. I have edited the post with an attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2014, 12:42 PM
  2. Decoding an excel formula
    By nadeemsmarty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 01:15 PM
  3. Encoding-Decoding
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2014, 02:33 AM
  4. decoding formula issue
    By Ricersux in forum Excel General
    Replies: 1
    Last Post: 02-18-2008, 12:02 PM
  5. Decoding an old macro
    By WendiL99 in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 10:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1