Results 1 to 16 of 16

IF and IF(And Formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2010
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    70

    Question IF and IF(And Formula

    I'm currently using the following formula.


    =IF($A13="LM Coordinated Audiences","STG Led",IF($A13="Workload Optimized Infrastructure","STG Led",IF($A13="Workload Optimized Systems","STG Led",IF($A13="STG - Competitive & Install","STG Led",IF($A13="LM Targeted Need-States","STG Led"," ")))))
    I need to add to this formula the following:

    If column A = Industry Leadership & column B = one of the following countries, then call it "STG Led"

    Countries:
    GMU-ASEAN
    GMU-CEE
    GMU-GCG
    GMU-India-South Asia
    GMU-Korea
    GMU-LA-Brazil
    GMU-LA-Mexico
    GMU-LA-SSA
    GMU-MEA
    NEE-Alps
    NEE-Nordic
    SWE-France
    SWE-Italy

    1st, I don't know how to do the formula, and 2nd I think the formula would be too long. So, I'm struggling with what would be my best option. I've attached a spreadsheet. Thanks for any help you can provide.
    Attached Files Attached Files
    Last edited by Koda7; 03-03-2011 at 02:00 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1