+ Reply to Thread
Results 1 to 4 of 4

Help with nested IfThen Macro

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    5

    Help with nested IfThen Macro

    Hi there -

    I'm new to macros and having a hard time wrapping my head around the IfThen vs IfThenElse scenarios.

    I have a spreadsheet with the following rows:

    Sort NewRenew NeedsApproval ClubName
    1 New Yes
    1 Renew
    3 New Yes


    I'm trying to set up a formula or macro that will do the following:
    If NeedsApproval is blank, return "" in ClubName column
    If NeedsApproval = Yes, then (if Sort = 1, return "Super Fancy Pants" in ClubName column; if Sort = 3, return "Kinda Fancy Pants" in ClubName column)

    If anyone could point me in the right direction, I would great appreciate it!
    Thanks so much

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Help with nested IfThen Macro

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-12-2015
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    5

    Re: Help with nested IfThen Macro

    Thanks so much for the reply, AB33!

    Within the Sort # and ClubName pairing, there are 6 options. Do you know if it will present an issue to building out the formula to include that many IF(AND statements?

  4. #4
    Registered User
    Join Date
    11-12-2015
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    5

    Re: Help with nested IfThen Macro

    Nevermind, I actually just answered my own reply - it works just fine

    Thanks again - you nailed it with your help/suggested formula!

+ 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. ifthen problem
    By lschwinkendorf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2015, 02:40 PM
  2. complicated IFTHEN formula
    By Nostradamus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2013, 02:18 PM
  3. Replies: 1
    Last Post: 06-29-2012, 03:27 PM
  4. [SOLVED] IFTHEN Statements and Dates
    By Rapacious in forum Excel General
    Replies: 6
    Last Post: 04-10-2012, 07:06 PM
  5. Vlookup or Embedded IfThen?
    By BusyEvent in forum Excel General
    Replies: 4
    Last Post: 02-07-2012, 01:14 PM
  6. SumProduct & IFThen, and other formulas
    By DCMADiva87 in forum Excel General
    Replies: 2
    Last Post: 08-30-2010, 04:29 PM
  7. [SOLVED] if and or ifthen?
    By Pam in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-17-2006, 02:05 PM

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