Results 1 to 12 of 12

MID function not working properly

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2017
    Location
    Mex
    MS-Off Ver
    365
    Posts
    4

    MID function not working properly

    So I created a concat formula to return column names all the way to "ZZ"; however, it's returning incorrect values for the second letter after "ai" and I can't seem to figure out why. The piece of formula misbehaving is the following (it has been simplified for convenience, but it works the same... or rather doesn't):

    =(MID("abcdefghijklmnopqrstuvwxyz",(38/26-(QUOTIENT(38-1,26)))*26,1))

    The result of start_num's argument is, of course, 12 (the 38 is AL's column number); HOWEVER, the letter given by MID is actually "k" (11th character), not "l", and short of actually sticking a "12" there, I haven't been able to make it work.


    This is one of those "optimization" experiments that ends up taking so much more time than just doing everything the "slow and inconvenient way"...
    Attached Files Attached Files
    Last edited by squashedmos; 12-28-2020 at 04:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. =COUNTA function not working properly
    By Stona in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2020, 11:19 AM
  2. IF OR AND Function not working properly
    By cbrazeau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2020, 10:06 AM
  3. [SOLVED] IF Function Not working properly
    By kgtrader in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-31-2020, 07:52 AM
  4. [SOLVED] IndexMatch function not working properly
    By bubai in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2015, 06:04 AM
  5. [SOLVED] Max Function Not Working Properly
    By STU22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2015, 07:41 PM
  6. Sums function not working properly...
    By Edrodriguez in forum Office 365
    Replies: 2
    Last Post: 05-18-2015, 09:59 AM
  7. Day Function Not Working Properly
    By clh7837 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 12:51 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