+ Reply to Thread
Results 1 to 3 of 3

Help with a isnumber, iferror, search formula

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Help with a isnumber, iferror, search formula

    Hi can someone help me with a formula please?.....

    I want to have 0,1 or 2 in column B depending on text in column A

    Column A Column B
    Macks 1
    Macks/Baxter 2
    CFL 0
    CFL/Langmead 1

    So if the cell doesn't contain CFL and it doesn't contain a "/" then its 1
    If it doesn't contain CFL and it does contain a "/" its 2
    If its CFL only its 0
    it it contains CFl and it contains a "/" its 1

    I have tried lots of different ways and it works almost except it wont work on either the CFL/ or the MACKS/BAXTER

    this is the formula I have at the moment and have stopped at

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But it returns 2 where its CFL/

    Any help on this would be very appreciated as ive been spending the last hour or so trying to get his right....

    Thanks

    Dan

  2. #2
    Registered User
    Join Date
    10-08-2015
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    5

    Re: Help with a isnumber, iferror, search formula

    excelforum04.12.xlsx

    Follows attached the solution. I cannot paste the formula only because my excel is in portuguese (brazilian here).

    Hope it helps.

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Help with a isnumber, iferror, search formula

    that's spot on thank you very much raulfloyd

+ 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] IF AND ISNUMBER SEARCH formula bringing back Value
    By Icehockey44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2015, 11:03 AM
  3. [SOLVED] IFERROR or ISNUMBER Help
    By artiststevens in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2014, 04:41 PM
  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