Results 1 to 6 of 6

If then statement, multiple conditions, multiple actions using OR

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Atlanta, GA
    MS-Off Ver
    MS Excel 365
    Posts
    19

    Post If then statement, multiple conditions, multiple actions using OR

    I am having trouble using a fairly simple If then statement using OR. I have attached a sample file. I am simply trying to create a field with the new product group name, based on the old name. Column C is the old product group. Column D is where I want the new product group name to appear. In one statement, I want the formula to spell out:

    if C2 is Tools_Service then D2 is TLS OR

    if C2 is Software_Service then D2 is SAAS OR

    if C2 is Managed_Service then D2 is MSP OR

    if C2 is Cloud_Computing then D2 is CLD OR

    if C2 is Consulting_Service then D2 is CSLT OR

    if C2 is Angel_Funding then D2 is AFD
    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 conditions and multiple actions-- Can it be done?
    By HeatherBelle79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-14-2018, 07:05 PM
  2. IF Statement with Multiple Conditions and Multiple True/False Results
    By ellesutgr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2015, 04:51 PM
  3. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  4. [SOLVED] Multiple Actions with an IF Statement
    By HangMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2013, 12:03 PM
  5. Replies: 6
    Last Post: 10-13-2011, 06:38 AM
  6. If Statement with multiple conditions
    By Cdoyle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2011, 10:58 AM
  7. If statement using multiple conditions
    By SCOOBYDOO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM

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