+ Reply to Thread
Results 1 to 4 of 4

Experiment results need ranking using if function with multiple conditions, help please?

  1. #1
    Registered User
    Join Date
    10-19-2014
    Location
    england
    MS-Off Ver
    office 14
    Posts
    3

    Experiment results need ranking using if function with multiple conditions, help please?

    There are 5 conditions i need to use to rank my results, these are the instructions

    In an adjacent column in Excel, calculate the number of “Rule of 5 violations”. - Aim to do this in a single column by adding up a series of “IF” functions to test whether each column (or the sum of several columns) violates the associated “Rule of 5”. (Take a look at the Lipinski rules & you will be able to work it out … you can see the format for the IF statement by clicking on the “function” button.)

    the rules are
    Lipinski found that poor absorption or permeation of a drug is more likely when:
     Molecular weight > 500 amu
     Log P > 5
     No. of H-bond donors > 5
     No. of H-bond acceptors > 10
    Scigress can be used to calculate each of these properties:
     No. of H-bond donors can be modelled by: - OH (hydroxyl) - NH2 (amine) - NH- (secondary amine)
     No. of H-bond acceptors can be modelled by: - O atoms - N atoms

    So my results are for each rules, molecular weight, log p, etc so how can how would i use an if function to rank the results? see attachment. absorption.xlsx

  2. #2
    Registered User
    Join Date
    10-19-2014
    Location
    england
    MS-Off Ver
    office 14
    Posts
    3

    Re: Experiment results need ranking using if function with multiple conditions, help pleas

    Any help with this is really appreciated, ive been struggling with it all day and can not find a way to do it.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,800

    Re: Experiment results need ranking using if function with multiple conditions, help pleas

    Hi, welcome to the forum

    Forum rules require you to wait at least a day before "bumping" your thread to the top of the list (let alone 2 minutes?). Besides, many members will only look at threads that have no replies, by bumping your thread, it now shows as having a "reply"

    OK, having said that, To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

  4. #4
    Registered User
    Join Date
    10-19-2014
    Location
    england
    MS-Off Ver
    office 14
    Posts
    3

    Re: Experiment results need ranking using if function with multiple conditions, help pleas

    Sorry just forgot to add to the end of my post my appreciation for any replies. thanks

+ 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] Multiple Timer for Experiment
    By costelveaceslav in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-25-2014, 02:08 AM
  2. Replies: 3
    Last Post: 05-18-2014, 01:14 PM
  3. Multiple IF, vlookup conditions and varying results
    By dh1231 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2014, 12:14 PM
  4. [SOLVED] Excel Ranking with multiple conditions
    By happyahamed in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2013, 08:46 AM
  5. one formula wiht multiple conditions and results..
    By Pavan Shetty in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-13-2012, 04:48 AM

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