+ Reply to Thread
Results 1 to 8 of 8

Logical function based on multiple columns

  1. 02-03-2015, 02:26 PM #1
    TVRSD
    TVRSD is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Washington State
    MS-Off Ver
    2013
    Posts
    3

    Logical function based on multiple columns

    I am not an excel wiz by any stretch, but have a working knowledge of using formulas to populate a column based on other columns. I cannot figure out how to generate a "TRUE/FALSE" based on what is located in 5 other columns. If any of the following are true, I need the last column to show TRUE. If none of them are true, I need it to show "FALSE"

    Need Column Z to be "TRUE" if:

    Column G is "0" AND Column U is 28 or higher
    OR
    Column G is "1" AND Column U is 45 or higher
    OR
    Column W is 90 or higher


    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-03-2015, 02:46 PM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Logical function based on multiple columns

    Try

    =OR(W2>=90,AND(G2=0,U2>=28),AND(G2=1,U2>=45))
    Reply With QuoteRegister To Reply
  3. 02-03-2015, 02:46 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Logical function based on multiple columns

    z4=if(OR(and(G4=0,U4>=28),and(G4=1,U4>=48),W4>=90),"true","false")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 02-03-2015, 02:53 PM #4
    TVRSD
    TVRSD is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Washington State
    MS-Off Ver
    2013
    Posts
    3

    Re: Logical function based on multiple columns

    Well, rats.

    =OR(W2>=90,AND(G2=0,U2>=28),AND(G2=1,U2>=45)) still gives me a FALSE, even if one of the conditions is met.

    z4=if(OR(and(G4=0,U4>=28),and(G4=1,U4>=48),W4>=90),"true","false") doesn't give me anything at all (including wiping out the next column =IF(Z6,"Y","N"), which now just reads "VALUE)

    UPDATE!!I just noticed that the line number wasn't right, so I altered that.
    =OR(W4>=90,AND(G4=0,U4>=28),AND(G4=1,U4>=45)) appears to work great!


    Thanks!
    Last edited by TVRSD; 02-03-2015 at 02:56 PM.
    Reply With QuoteRegister To Reply
  5. 02-03-2015, 03:02 PM #5
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Logical function based on multiple columns

    You're welcome.
    Reply With QuoteRegister To Reply
  6. 02-03-2015, 03:09 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Logical function based on multiple columns

    See the attached file with the formula in cell Z4.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-03-2015, 03:13 PM #7
    TVRSD
    TVRSD is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Washington State
    MS-Off Ver
    2013
    Posts
    3

    Re: Logical function based on multiple columns

    Ah...oeldere, now I see! Z4 was not the beginning of the formula, but rather the cell into which I should place the formula. Yes, that works great, too...thanks!
    Reply With QuoteRegister To Reply
  8. 02-03-2015, 03:24 PM #8
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Logical function based on multiple columns

    Thanks for the reply.

    Glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 Logical Tests in an IF function
    By scrouse14 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-26-2014, 03:15 PM
  2. if function: preforming logical tests on multiple sheets
    By sai19 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2013, 09:15 AM
  3. IF function performing logical test on multiple cells
    By Omni in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 12-01-2012, 01:37 AM
  4. multiple logical tests as argument in Database function
    By riwiseuse in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-09-2009, 07:45 AM
  5. Logical Function - Multiple IF statements
    By vnsrod2000 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1