+ Reply to Thread
Results 1 to 5 of 5

Wildcards in iif/then statements

  1. 08-08-2013, 09:53 AM #1
    ballerado
    ballerado is offline
    Registered User
    Join Date
    08-07-2013
    Location
    Texas
    MS-Off Ver
    Excel 2013
    Posts
    5

    Wildcards in iif/then statements

    I need an equation that says "IF column M contains data, display the data in column Q, if it does not contain data, return "Unknown"" I have been trying for several hours but cant get the wildcard combination right. Can anyone help with this?
    Reply With QuoteRegister To Reply
  2. 08-08-2013, 09:56 AM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Wildcards in iif/then statements

    Not so sure what you mean by "wildcard combination", but try...

    =IF(M2<>"",Q2,"Unknown")

    ...if this does not do it, please show what you have tried.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 08-08-2013, 09:59 AM #3
    ballerado
    ballerado is offline
    Registered User
    Join Date
    08-07-2013
    Location
    Texas
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Wildcards in iif/then statements

    Thats the one! I didnt know you would need the <> symbols thanks a ton. rep given!
    Reply With QuoteRegister To Reply
  4. 08-08-2013, 10:01 AM #4
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Wildcards in iif/then statements

    You're welcome…glad you have a workable solution and thanks for the feedback...

    (The 'rep' also )
    Reply With QuoteRegister To Reply
  5. 08-08-2013, 10:01 AM #5
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Wildcards in iif/then statements

    You're welcome…glad you have a workable solution and thanks for the feedback...

    (The 'rep' also )
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reading If statements and formulating values from if statements
    By crnam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:20 AM
  2. Wildcards in SUMIF statements
    By peterandrewsuk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2013, 05:04 PM
  3. Using Wildcards in IF statements
    By mmills79@hotmail.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2012, 10:42 AM
  4. Nested IF statements or CHOOSE statements needed for multiple conditions formula
    By salmansaif in forum Excel General
    Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  5. [SOLVED] operator statements, shorting when reusing one of the statements?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1