+ Reply to Thread
Results 1 to 3 of 3

IF Statement with Multiple Conditions and Multiple True/False Results

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Prairieville, LA
    MS-Off Ver
    2013 Windows
    Posts
    3

    IF Statement with Multiple Conditions and Multiple True/False Results

    Here is a sample of my data. I am trying to place the indicated scenario in E133.
    E125 Initial Score: 93.1
    E126 Initial Decile Rating: 2.5 (This score is derived how E125 is answered.)
    E131 Statistical P-Value: 0.489
    E132 Statistical P-Value <0.050: No (This score is derived how E131 is answered.)
    E133 Adjusting Rating: 2.5 (This is where I need an IF statement)

    So if E126 is 2.5 or 3.0 and E132=No, then E133 stays the same meaning either 2.5 or 3.0 respectively.

    If E126 is <2.5 or >3.0 and E132=No, then E133=E126+0.5.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,176

    Re: IF Statement with Multiple Conditions and Multiple True/False Results

    If E126 > 2.5 and < 3.0 ???? Or is it if any other value than 2.5 and 3.0

    Possibly ...???

    IF(E132="No",IF(OR(E126=2,5,E126=3),E126,E126+0.5),0)

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    Prairieville, LA
    MS-Off Ver
    2013 Windows
    Posts
    3

    Re: IF Statement with Multiple Conditions and Multiple True/False Results

    E126 = any other value other than 2.5 or 3.0

+ 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. True/False for Multiple conditions and formats in a range of cells
    By Vatoemperor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2015, 03:51 PM
  2. [SOLVED] Comparing Multiple columns across worksheets and returning a True/False statement
    By RoryK in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-11-2015, 10:33 PM
  3. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  4. IF Statement combining multiple 'IF TRUE' conditions
    By shaunguyver in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2015, 05:59 AM
  5. IF statement with multiple true false variables
    By tommyt34uw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2014, 01:17 PM
  6. IF STATEMENT returns False, even though the results are true
    By Biolu527 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 11:21 AM
  7. [SOLVED] My If statement results in False when actually true
    By papa jonah in forum Excel General
    Replies: 7
    Last Post: 03-17-2005, 08:06 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