Consulting

Results 1 to 2 of 2

Thread: Excel formula

  1. #1
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location

    Excel formula

    I want to choose a folder's tab location, depending on the content of the label put on the folder (mail merge).

    So, if the first letter of the folder is A through I, it's 1, J through R is 2, and S through Z is 3.

    What's the easiest way to write that formula? I know how it starts!!

    =if(

    ROFL!!
    ~Anne Troy

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,147
    Location
    Quote Originally Posted by Dreamboat
    I want to choose a folder's tab location, depending on the content of the label put on the folder (mail merge).

    So, if the first letter of the folder is A through I, it's 1, J through R is 2, and S through Z is 3.

    What's the easiest way to write that formula? I know how it starts!!

    =if(

    ROFL!!
    I have no idea where you got the IF from, but assuming you only want A-Z, and it is in A1

    =(INT((CODE(A1)-65)/9)+1)*(A1>="A")*(A1<="Z")

Posting Permissions

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