+ Reply to Thread
Results 1 to 3 of 3

Thread: multiple outcomes for a single cell program(help)

  1. 03-13-2011, 10:40 PM #1
    krk2503
    krk2503 is offline
    Registered User
    Join Date
    03-13-2011
    Location
    springboro, ohio
    MS-Off Ver
    Excel 2007
    Posts
    6

    multiple outcomes for a single cell program(help)

    A1+B1=C1 if A1=1 & B1=1 then C1=0 and if A1=0 & B1=1 then C1=1 and if A1=0 & B1=0 then C1=1. can this be done and how
    Last edited by romperstomper; 07-08-2011 at 05:28 PM. Reason: Mark solved
    Reply With Quote Reply With Quote
  2. 03-13-2011, 10:44 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Guru ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    traded up
    MS-Off Ver
    2003 & 2010
    Posts
    1,905

    Re: multiple outcomes for a single cell program(help)

    How about:

    =NOT(AND(A1,B1))*1
    Cheers,
    “To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
    Reply With Quote Reply With Quote
  3. 03-13-2011, 10:48 PM #3
    krk2503
    krk2503 is offline
    Registered User
    Join Date
    03-13-2011
    Location
    springboro, ohio
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: multiple outcomes for a single cell program(help)

    thank you ConneXionLost
    Reply With Quote Reply With Quote
+ 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)

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.2.0