Results 1 to 6 of 6

Help Replace value based on a logic statement

Threaded View

abosiiqi Help Replace value based on a... 07-23-2014, 02:17 AM
dragavs Re: Help Replace value based... 07-23-2014, 02:30 AM
abosiiqi Re: Help Replace value based... 07-23-2014, 02:38 AM
newdoverman Re: Help Replace value based... 07-23-2014, 10:16 AM
abosiiqi Re: Help Replace value based... 07-23-2014, 10:02 PM
newdoverman Re: Help Replace value based... 07-23-2014, 10:46 PM
  1. #1
    Registered User
    Join Date
    07-23-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    3

    Question Help Replace value based on a logic statement

    Hi All,
    i need help to make an logic statement for my data.
    i have this data:

    1# T/T
    2# C/C

    4# T/T
    5# T/C
    6# T/C
    7# T/C
    8# C/C
    9# T/T
    10# T/T

    Based on information, I want to replace whatever (T/T)or(G/G)or(C/C)or(A/) on 1#row with "A/A" and (T/T)or(G/G)or(C/C)or(A/A) on 2#row with "B/B". And then,from 4#row until 10#row i want to use logical replacement if each row contain "T/G/C/A" like 1#row it should be replaced with "A",and if each row contain "C" it should be replaced with "B".

    Here is the result that i want:
    1# T/T >>> 1# A/A
    2# C/C >>> 2# B/B

    4# T/T >>> 4# A/A
    5# T/C >>> 5# A/B
    6# T/C >>> 6# A/B
    7# T/C >>> 7# A/B
    8# C/C >>> 8# B/B
    9# T/T >>> 9# A/A
    10# T/T >>> 10# A/A


    is there any logical function that i can use?
    Thank you in advance.. :D
    Last edited by abosiiqi; 07-23-2014 at 02:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF statement Logic..
    By inincubus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 05:27 PM
  2. Replace cell value based on a logic statement
    By spujr in forum Excel General
    Replies: 5
    Last Post: 01-17-2014, 04:56 PM
  3. Logic Statement
    By jeanmuhree in forum Excel General
    Replies: 5
    Last Post: 02-20-2012, 03:10 AM
  4. Logic Statement
    By abierly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 02:15 PM
  5. Two Logic tests in an IF Statement
    By timmadge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2006, 11:15 AM

Tags for this Thread

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