+ Reply to Thread
Results 1 to 2 of 2

Using conditional formatting to assign binomial value to an and/or double condition

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Cincinnati, OH, USA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Using conditional formatting to assign binomial value to an and/or double condition

    Capture.jpg

    For anyone who cannot see the image, here is the text:

    Here is the conundrum (in simplified terms):
    I need to make a formula that will say if students play a sport. I have the data inputted with every student constituting a row, and different statistics for each column.
    The other statistics (GPA, Shooting %, RBI) are irrelevant to this question and hence marked with an "x"
    The sheet uses binomial coding where 0 signifies a "No" and 1 signifies a "Yes," (and no, I cannot change this formatting)
    If I need to know how many students play any sport, how can I create a formula that will give me a binomial (0 or 1) answer for the final column, "does the student play sports?"
    [I have filled it in with the expected (human-generated) answer to test the formula]

    Ex table
    GPA Play Basketball? Shooting Percentage Play Baseball? RBI Play sports?
    Student1 x 0 x 1 x 1
    Student2 x 1 x 0 x 1
    Student3 x 1 x 1 x 1
    Student4 x 1 x 1 x 1
    Student5 x 0 x 0 x 0
    Student6 x 0 x 1 x 1
    Student7 x 0 x 1 x 1
    Student8 x 0 x 0 x 0
    Student9 x 1 x 0 x 1
    Student10 x 1 x 0 x 1
    Student11 x 1 x 1 x 1

    I have tried making the final column
    = IF(SUM(C10, E10)>0, 1, 0)
    but Excel cannot process that command
    = IF(SUMPRODUCT(C10, E10)<1, 0, 1)
    but any student who plays one sport, but not the other, will not be counted


    Do you have any suggestions?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Using conditional formatting to assign binomial value to an and/or double condition

    =--(sum(c2,e2)>0)

    But your example formula works as well.

    = IF(SUM(C2, E2)>0, 1, 0)
    Cheers
    Andy
    www.andypope.info

+ 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] Conditional Formatting for 2 condition
    By MyOnion in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2013, 03:29 AM
  2. Conditional formatting double space intermittently working
    By RefillMyInk in forum Excel General
    Replies: 1
    Last Post: 08-24-2011, 11:59 AM
  3. Double conditional formatting
    By khansen in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-29-2009, 02:22 PM
  4. More condition in Conditional Formatting
    By ondra in forum Excel General
    Replies: 3
    Last Post: 06-16-2008, 03:55 AM
  5. 4 condition conditional formatting
    By jeffg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2005, 02:05 PM

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