+ Reply to Thread
Results 1 to 3 of 3

Using multiple IF statements in Excel Base off of three critieria

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Unhappy Using multiple IF statements in Excel Base off of three critieria

    I am trying to build a nested If statement I have three columns they are either going to say "yes" or "no" I need to write a If statement that gives me the below

    If all three columns have "yes" then I want to return 100%
    If only two yes and one no in all three columns then I want to return 66.6%
    If only one yes and the rest no I want to return 33.3%

    Basically

    1 yes = 33.3%
    2 yes= 66.6%
    3 yes = 100%
    or if all three columns have a No then it would be 0%

    I am not sure if I am doing this correct this is the formula I'm trying and keep getting an error forgive me but I am not up to par with If statements

    IF((BC5="YES",BD5="YES",BE5="NO"),66.6%,IF(BC5="YES",BD"NO",BE5="NO"),33.3%,IF(BC5="YES",BD"YES",BE5="YES"):,"100%,0%)))


    Any help would be apprecaited

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Using multiple IF statements in Excel Base off of three critieria

    Hi cardonas,

    Welcome to the Forum!

    Try:
    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Using multiple IF statements in Excel Base off of three critieria

    Another way:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and format % as many decimal places as needed.
    Dave

+ 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. Replies: 6
    Last Post: 11-13-2014, 11:26 AM
  2. =averageif( ) with multiple critieria
    By damonjasso in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-26-2014, 04:51 AM
  3. Copy rows in multiple sheets given a critieria and merge them in another sheet
    By on2mars in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2014, 06:27 AM
  4. Lookupif on Multiple Critieria
    By akia in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-26-2013, 09:41 AM
  5. Central Excel Data base with multiple user inputs
    By raveendra in forum Excel General
    Replies: 1
    Last Post: 11-04-2012, 12:16 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