Results 1 to 8 of 8

Want to make short a formula

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2021, Google Sheet
    Posts
    38

    Want to make short a formula

    Hi,

    I have created a formula to find out last digit of 18 digit numbers. Actually I got this formula by using lugn algorithm. Here is the formula. Also attached a sample file in this regards.
    Formula: copy to clipboard

    =IFERROR(A2&IF(VALUE(RIGHT(MID(A2,1,1)+IF(LEN(MID(A2,2,1)*2)=2,RIGHT(MID(A2,2,1)*2,1)+LEFT(MID(A2,2,1)*2,1),MID(A2,2,1)*2)+MID(A2,3,1)+IF(LEN(MID(A2,4,1)*2)=2,RIGHT(MID(A2,4,1)*2,1)+LEFT(MID(A2,4,1)*2,1),MID(A2,4,1)*2)+MID(A2,5,1)+IF(LEN(MID(A2,6,1)*2)=2,RIGHT(MID(A2,6,1)*2,1)+LEFT(MID(A2,6,1)*2,1),MID(A2,6,1)*2)+MID(A2,7,1)+IF(LEN(MID(A2,8,1)*2)=2,RIGHT(MID(A2,8,1)*2,1)+LEFT(MID(A2,8,1)*2,1),MID(A2,8,1)*2)+MID(A2,9,1)+IF(LEN(MID(A2,10,1)*2)=2,RIGHT(MID(A2,10,1)*2,1)+LEFT(MID(A2,10,1)*2,1),MID(A2,10,1)*2)+MID(A2,11,1)+IF(LEN(MID(A2,12,1)*2)=2,RIGHT(MID(A2,12,1)*2,1)+LEFT(MID(A2,12,1)*2,1),MID(A2,12,1)*2)+MID(A2,13,1)+IF(LEN(MID(A2,14,1)*2)=2,RIGHT(MID(A2,14,1)*2,1)+LEFT(MID(A2,14,1)*2,1),MID(A2,14,1)*2)+MID(A2,15,1)+IF(LEN(MID(A2,16,1)*2)=2,RIGHT(MID(A2,16,1)*2,1)+LEFT(MID(A2,16,1)*2,1),MID(A2,16,1)*2)+MID(A2,17,1)+IF(LEN(MID(A2,18,1)*2)=2,RIGHT(MID(A2,18,1)*2,1)+LEFT(MID(A2,18,1)*2,1),MID(A2,18,1)*2),1))=0,0,10-VALUE(RIGHT(MID(A2,1,1)+IF(LEN(MID(A2,2,1)*2)=2,RIGHT(MID(A2,2,1)*2,1)+LEFT(MID(A2,2,1)*2,1),MID(A2,2,1)*2)+MID(A2,3,1)+IF(LEN(MID(A2,4,1)*2)=2,RIGHT(MID(A2,4,1)*2,1)+LEFT(MID(A2,4,1)*2,1),MID(A2,4,1)*2)+MID(A2,5,1)+IF(LEN(MID(A2,6,1)*2)=2,RIGHT(MID(A2,6,1)*2,1)+LEFT(MID(A2,6,1)*2,1),MID(A2,6,1)*2)+MID(A2,7,1)+IF(LEN(MID(A2,8,1)*2)=2,RIGHT(MID(A2,8,1)*2,1)+LEFT(MID(A2,8,1)*2,1),MID(A2,8,1)*2)+MID(A2,9,1)+IF(LEN(MID(A2,10,1)*2)=2,RIGHT(MID(A2,10,1)*2,1)+LEFT(MID(A2,10,1)*2,1),MID(A2,10,1)*2)+MID(A2,11,1)+IF(LEN(MID(A2,12,1)*2)=2,RIGHT(MID(A2,12,1)*2,1)+LEFT(MID(A2,12,1)*2,1),MID(A2,12,1)*2)+MID(A2,13,1)+IF(LEN(MID(A2,14,1)*2)=2,RIGHT(MID(A2,14,1)*2,1)+LEFT(MID(A2,14,1)*2,1),MID(A2,14,1)*2)+MID(A2,15,1)+IF(LEN(MID(A2,16,1)*2)=2,RIGHT(MID(A2,16,1)*2,1)+LEFT(MID(A2,16,1)*2,1),MID(A2,16,1)*2)+MID(A2,17,1)+IF(LEN(MID(A2,18,1)*2)=2,RIGHT(MID(A2,18,1)*2,1)+LEFT(MID(A2,18,1)*2,1),MID(A2,18,1)*2),1))),"")


    This formula is working fine. I need this formula in short. Please help me by doing this.
    Attached Files Attached Files
    Last edited by davesexcel; 09-15-2020 at 01:29 PM.

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: 01-16-2018, 06:52 PM
  2. Short issue with formula.
    By sarstep1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2017, 11:09 AM
  3. How to make the short border?
    By ajing in forum Excel General
    Replies: 3
    Last Post: 01-27-2016, 02:56 PM
  4. Want to short formula instead of using of CONCATENATE
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-21-2014, 03:28 AM
  5. Userform find/search text, can i make it's short code ?
    By johnreid7477 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-03-2014, 04:28 PM
  6. Shortening of long array formula by short formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2013, 05:51 AM
  7. In search of a formula short cut...
    By johnnioaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2012, 03:10 PM

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