+ Reply to Thread
Results 1 to 3 of 3

nested IF statement or AND? trying to write an IF statement with multiple conditions

  1. #1
    Registered User
    Join Date
    06-05-2015
    Location
    Philadelphia
    MS-Off Ver
    2013
    Posts
    14

    nested IF statement or AND? trying to write an IF statement with multiple conditions

    So I have two columns with two sets of values. I have a third column with another value. And I have a forth column that I want to return my data into.

    What I'm trying to write is an IF statement that says if the value of my third column falls within the values of my first two columns, fill the fourth column with a specific number.


    SO:

    A-B-C-D
    1-4-3-?

    A and B have a range between 1 and 4, C is between those two values, so I want it to return the value 2 to D

    This is what I wrote, and it doesn't work:

    =IF(A1>B1, 2, 0 IF(A<C1, 2, 0))

    It says I'm making "too many arguments". I've read some tutorials that say I should use AND (which I have zero experience with), but I've used a nested IF statement to do something similar before.

    Anyone have any thoughts?

    Thanks!

  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
    27,887

    Re: nested IF statement or AND? trying to write an IF statement with multiple conditions

    =if(and(c1>=a1,c1<=b1),2,0)

  3. #3
    Registered User
    Join Date
    06-05-2015
    Location
    Philadelphia
    MS-Off Ver
    2013
    Posts
    14

    Re: nested IF statement or AND? trying to write an IF statement with multiple conditions

    Thank you.

+ 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. Nested If Statement with Multiple Logical Conditions
    By gatefire08 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2014, 12:17 PM
  2. [SOLVED] 3 conditions coming from one cell.. Nested If Statement??
    By trosasco in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2013, 02:52 PM
  3. Replies: 11
    Last Post: 10-26-2011, 03:24 PM
  4. Nested IF statement 3 conditions 3 outcomes
    By Nick_in_Dubai in forum Excel General
    Replies: 1
    Last Post: 03-12-2009, 04:38 AM
  5. Replies: 6
    Last Post: 01-14-2009, 06:59 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