+ Reply to Thread
Results 1 to 2 of 2

nested If condition to match two halves of cells

Hybrid View

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

    nested If condition to match two halves of cells

    hi to all,

    I am working on some data there I would like to use nested if condition to solve my problem. This is how my table looks like
    SX0001A SX0002A SX362 SX0001A SX0002A SX362
    P1 C/C C/C A/A
    P2 A/A G/G T/T
    1 C/C -/- A/A 0 0 0
    2 -/- C/C A/A 0 0 0
    3 C/A G/G T/A 2 1 2
    4 A/A C/G T/T 1 2 1

    in E4 cell I would like to give score 1 if B4 cell matches exactly with B3 cell
    in E4 cell I would like to give score 0 if B4 cell does not match with B3 cell
    in E4 cell I would like to give score 2 if B4 cell have half of B2 and half of B3 i.e. C/A or A/C
    I tried nested if condition to solve it but I am getting problem in matching two halves of to cells to score. I am requesting you to help me. I am attaching sample file for better understanding of my problem.
    Thanks in advance
    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,999

    Re: nested If condition to match two halves of cells

    Try

    E4=IF(EXACT(B4,B$3),1,IF(OR(B4=LEFT(B$3,1)&"/"&LEFT(B$2,1),B4=RIGHT(B$2,1)&"/"&RIGHT(B$3,1)),2,0)) and drag over the cells and down.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. [SOLVED] Nested If condition
    By nawas in forum Excel General
    Replies: 7
    Last Post: 02-05-2016, 01:42 AM
  2. [SOLVED] Nested If condition
    By nawas in forum Excel General
    Replies: 3
    Last Post: 01-15-2015, 05:00 AM
  3. [SOLVED] Nested IF Condition
    By Enigma Trio in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2014, 01:35 AM
  4. [SOLVED] Match string between cells in two tables and return a value based on condition
    By shavar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 04:13 PM
  5. [SOLVED] How to get answer if two condition match in two different cells
    By devawad in forum Excel General
    Replies: 2
    Last Post: 11-16-2013, 01:45 AM
  6. Replies: 1
    Last Post: 03-20-2006, 04:10 PM
  7. halves
    By MBlake in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-12-2005, 06:05 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