Results 1 to 8 of 8

Logical function based on multiple columns

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1