Results 1 to 8 of 8

Text queries within nested IF formulas to provide required output

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2015
    Location
    Scotland
    MS-Off Ver
    2014
    Posts
    4

    Text queries within nested IF formulas to provide required output

    Attempting a formula which is quite possibly beyond my excel knowledge!
    I have a cell which showes either 3 options - Full Disposal, No Disposal, Part Disposal. I am attempting to check further cells depending on the initial value of the 'Disposals' cell.

    Formula -

    '=IF(AND(ISNUMBER(SEARCH("Full Disposal",X42)),V42<0),"Error",IF(AND(ISNUMBER(SEARCH("No Disposal",X42)),V42<0),"Error",IF(AND(ISNUMBER(SEARCH("Part Disposal",X42)),V42<0,U42<0),"Error","Okay")

    If cell contains 'Full Disposal' & other query is true, show 'error', else check for other two types of disposal rinse and repeat.

    I think where i am going wrong is with regards to whethther the ISNUMBER(SEARCH) is providing the correct response to work?

    Any help much appreciated!
    Thanks
    Last edited by marky385; 09-11-2015 at 07:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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