+ Reply to Thread
Results 1 to 3 of 3

how to use if condition for more than one query

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    how to use if condition for more than one query

    Hi all,
    I am newly joined in this forum, I need help in solving this problem, my data looks like in my uploaded file
    I want to write IF condition to check for dummy SX1 whether P1 & P2 contains same letters or not, for this i written IF condition like this
    =if(G2=G1,"Equal","notequal") It means both G1 and G2 contains same letters for example GG, GG then it will give equal. I want to write IF condition for notequal condition for the cells contains even Z/Z also.
    Expected result is
    1 Parent SX1 SX2 SX3 SX4 SX1 SX2 SX3 SX4
    2 P1 AA GG Z/Z //
    3 P2 AA GG GG AA EQ EQ NE NE

    This is my if condition =IF(E1=E2,"EQ","NE"), but this condition giving NE for example SX3 and SX4 but i want those should be EQ. How can i write if condition in this situation?
    Thanks in advance
    Regards
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-08-2013
    Location
    Reigate
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: how to use if condition for more than one query

    You can put if statements within if statements.
    i.e.
    =IF(CONDITION1,OUTCOME1, IF(CONDITION2,OUTCOME2,OUTCOME3))

  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,933

    Re: how to use if condition for more than one query

    Hi and welcome to the forum

    Your sample and explanation are confusung (to me at least). It would be helpful is you could add a few sample answers to your file, so that we can see what you want...add them manually, and if necessary, explain how you arrived at those answers
    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)

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