+ Reply to Thread
Results 1 to 3 of 3

If Nesting

  1. #1
    Registered User
    Join Date
    10-28-2021
    Location
    Guatemala
    MS-Off Ver
    365
    Posts
    1

    If Nesting

    I have a database that was given to me however in the description it has the name of the product instead of having another cell with the product name so for instance in the description they have medicine for stomach pepto bismol. I did a if(isnumber(search("peto bismol"b2)),"pepto bismol",if etc but the problem is that there are a lot of products and I get the nesting 64 error is there another way I can do this so I donīt have to enter them in manually

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,228

    Re: If Nesting

    Please see the yellow banner with instructions on how to post a sample workbook.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    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,939

    Re: If Nesting

    And perhaps try adding some punctuation, so that we can better understand what you are asking?
    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

+ 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] Non nesting IFs
    By vicstone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2018, 05:00 PM
  2. Replies: 4
    Last Post: 02-26-2015, 06:10 AM
  3. IF and AND nesting
    By Perran in forum Excel General
    Replies: 5
    Last Post: 04-28-2012, 09:14 PM
  4. Nesting IF's and AND's...
    By neilcarden in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2007, 03:58 PM
  5. IF - Nesting... almost got it - need a bit of help
    By AngelaG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. IF - Nesting... almost got it - need a bit of help
    By Bill Kuunders in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  7. IF - Nesting... almost got it - need a bit of help
    By AngelaG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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