+ Reply to Thread
Results 1 to 3 of 3

Formula Help Needed: IF plus ISNUMBER plus SEARCH plus OR plus AND

  1. #1
    Registered User
    Join Date
    09-21-2016
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Question Formula Help Needed: IF plus ISNUMBER plus SEARCH plus OR plus AND

    Hi All,

    I'm relatively new to the formula functions of Excel (this is my first post) so I was hoping someone with more experienced may be able to help me!

    I'm trying to create a formula that says:

    IF cell N1 contains the string of text "Invoice" then cell U1 should equal cell F1. OR if If cell N1 contains the string of text "accrual" AND cell F1 is less than 0, then cell U1 should equal cell F1. Otherwise return nothing ("").

    The formula I currently have is:

    =IF(ISNUMBER(SEARCH("Invoice",$N1)),F1,""). However, I can't quite figure how to code the formula for the second part I wish to add (OR if If cell N1 contains the string of text "accrual" AND cell F1 is less than 0, then cell U1 should equal cell F1).

    Any help would be much appreciated.

    TOLJ

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formula Help Needed: IF plus ISNUMBER plus SEARCH plus OR plus AND

    Maybe this...
    =if(or(N1="*invoice*",and(N1="*"accrual*",F1<0)),F1,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-21-2016
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula Help Needed: IF plus ISNUMBER plus SEARCH plus OR plus AND

    Thanks FDibbins.

    I gave it a try but to no avail.

    I've been playing around and I believe I've got a formula to work. It may not be the best option though - open to any suggestions!

    =IF(COUNT(SEARCH("Invoice",$N1)),$F1,IF(AND($F1<0,COUNT(SEARCH("accrual",$N1))),$F1,""))

+ 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. [SOLVED] My =IF(ISNUMBER(SEARCH Formula is Not Working
    By thanhie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2022, 12:30 AM
  2. [SOLVED] using an OR statement inside a =if(isnumber(search( formula
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-03-2016, 11:23 AM
  3. [SOLVED] Help with a isnumber, iferror, search formula
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2015, 08:31 AM
  4. Need help with isnumber(search) Formula
    By lpretor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2013, 08:14 PM
  5. [SOLVED] Modification of a IF ISNUMBER SEARCH formula
    By zigojacko in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2013, 04:20 AM
  6. using IF(ISNUMBER(SEARCH formula
    By dkmanley in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-19-2011, 01:43 PM
  7. If, isnumber, lookup, search formula problem
    By jamieray in forum Excel General
    Replies: 3
    Last Post: 09-08-2011, 06:44 AM

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