+ Reply to Thread
Results 1 to 4 of 4

Joining IF formulas

  1. #1
    Registered User
    Join Date
    03-24-2011
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2007
    Posts
    35

    Joining IF formulas

    Dear all

    I am trying to join the following three IF formulas together in one formula however no luck. Each formula works individually in separate cells however would be ideal if it was one formula in one cell in one formula:

    =IF(AND(A1=0,B1>=1),"Yes")
    =IF(AND(A1>=1,B1=0),"No")
    =IF(AND(A1=0, B1=0),"Different")

    Any help will be much appreciated

    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Joining IF formulas

    =IF(AND(A1=0,B1>=1),"Yes",IF(AND(A1>=1,B1=0),"No",IF(AND(A1=0,B1=0),"Different","")))

    you link one in to the required response in the original if
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  3. #3
    Registered User
    Join Date
    03-24-2011
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Joining IF formulas

    Excellent. Works perfectly - tried the formula you posted but had a bracket after the true statement before starting the next If formula.

    Cheers for the help.

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Joining IF formulas

    no problem.

    remember if a post helps to hit the star button :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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