+ Reply to Thread
Results 1 to 1 of 1

Help IF Function with Multiple Conditions and Multiple Outcomes

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    17

    Lightbulb Help IF Function with Multiple Conditions and Multiple Outcomes

    Hi Folks

    I am trying to create IF Formula that will look at Condition 1 and Condition 2 formula and give the desire outcome as if A="xxx" and B="yyy" then give "Capital", "Expense" or "PM" as the answer. is there a way to do it, my excel is attached here on this thread

    Condition1 should always precede over Condition 2 and answer should be either "Capital", "Expense" or "PM"

    Thanks

    Chintu
    Attached Images Attached Images
    Attached Files Attached Files

+ 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. Using IF function for multiple outcomes
    By steeltownclown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2016, 02:26 PM
  2. [SOLVED] Using IF Function with AND and Multiple Outcomes
    By winninbird in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2015, 09:27 PM
  3. IFS function. Many IFS and multiple possible outcomes
    By MrHjordt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-14-2014, 05:15 PM
  4. IF function with multiple Trues, multiple outcomes
    By BiminiSharklab in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2014, 10:50 AM
  5. IF Function multiple possible outcomes?
    By Nomadski in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-11-2013, 05:41 PM
  6. [SOLVED] IF formula for mulitple conditions and multiple outcomes
    By kazthomas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 08:31 PM
  7. [SOLVED] If Function with multiple outcomes and accumulating numbers
    By Brainstorm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2012, 07:04 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