Results 1 to 2 of 2

nested If condition to match two halves of cells

Threaded 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

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