+ Reply to Thread
Results 1 to 3 of 3

Combining IF and AND functions error

  1. #1
    Registered User
    Join Date
    11-01-2017
    Location
    Netherlands
    MS-Off Ver
    Excel 2013
    Posts
    4

    Combining IF and AND functions error

    Hi,

    I am trying to set some conditions for the use of a method. There are several requirements to make method 1 applicable. I did insert the following function:

    =IF(AND(B11>0,10<B9<20,1.5<B12<2.5,0.5<B10<0.6,0.4<B16<1.5),Method 1 is applicable,Method 1 is not applicable)

    When I insert this functions I get an error, but when I replace the true en false values by ''Yes'' and ''No'' it works. Does it not show sentences but only words, or am I doing something wrong? I hope someone can help me with this.

    Kind Regards,

    Cem Akilli

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Combining IF and AND functions error

    welcome to the forum. try:
    =IF(AND(B11>0,B9>10,B9<20,B12>1.5,B12<2.5,B10>0.5,B10<0.6,B16>0.4,B16<1.5),"Method 1 is applicable","Method 1 is not applicable")

    you must have double quotes for texts. and you cant do 2 equations at once in excel such as 1.5<B12<2.5

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    11-01-2017
    Location
    Netherlands
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Combining IF and AND functions error

    Thank you for your fast response!

+ 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. Value Not Available Error when combining functions
    By vbaovac in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-12-2017, 01:09 PM
  2. [SOLVED] Error Message When Combining IF and COUNTIF Functions
    By EverClever in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2017, 04:50 PM
  3. [SOLVED] Combining IF and Sum functions.
    By dowell89 in forum Excel General
    Replies: 7
    Last Post: 11-11-2013, 09:10 AM
  4. Combining multiple functions>lookup/sum functions
    By mush106 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2013, 07:47 AM
  5. Combining two functions
    By ram09 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2013, 01:57 PM
  6. Combining If & And functions
    By marielav99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2010, 10:30 AM
  7. Combining IF OR and AND functions
    By andyp161 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2006, 01:10 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