+ Reply to Thread
Results 1 to 2 of 2

Nested find statement?

  1. #1
    Registered User
    Join Date
    07-06-2016
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    28

    Nested find statement?

    Hi there,

    I need a formula that tests for three criteria:
    1) if there is a "USD" in the cell return a "USD"
    2) if there is a "CAD" in the cell return a "CAD"
    3) if there is a "*Q" in the cell return a "*Q"

    Otherwise return a "-". The CAD/USD/*Q are not consistently in the same place in the text string.

    Thanks for the help!!!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Nested find statement?

    You marked your thread as solved, without comment. If that was a mistake, here is a formula that does what you want. Assumes data is in A1:

    =IF(ISNUMBER(SEARCH("USD",A1)),"USD",IF(ISNUMBER(SEARCH("CAD",A1)),"CAD",IF(ISNUMBER(SEARCH("*Q",A1)),"*Q","-")))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Nested IF statement error. Nested True statement is not triggering
    By Lucas7040 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2016, 11:41 AM
  2. [SOLVED] Nested IF Statement with OR Clause Only Processes First IF Statement
    By ExcelQuestFL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-09-2016, 04:30 PM
  3. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  4. [SOLVED] If statement to select data - nested statement - assistance
    By petitesouris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-29-2015, 09:55 PM
  5. [SOLVED] Nested If Statement - ISBLANK and ISNA in same statement?
    By Janc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-23-2013, 09:00 AM
  6. Using Find or Search in Nested IF statement - more efficiant way?
    By Bytor47 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2009, 10:43 AM
  7. Replies: 6
    Last Post: 01-14-2009, 06:59 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