+ Reply to Thread
Results 1 to 2 of 2

If Condition

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    If Condition

    Hi All,

    Can somebody help me with the formula im currently doing?

    here's the condition:

    IF Account Group = YSTP, YSHP
    AND Sales Organization = US52,USK7,US16
    AND Distribution Channel = All
    AND Division = All
    AND Delivery Priority = 10
    WHERE GSAP Attribute 2 <> 03 (Hypermarket)
    THEN Failed


    aTTACHED IS THE FILETRY.xlsb

  2. #2
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: If Condition

    You can use countifs
    http://www.techonthenet.com/excel/formulas/countifs.php
    Inveniam Viam Aut Faciam

+ 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: 7
    Last Post: 06-01-2015, 06:05 PM
  2. Condition formatting of multiple condition formatted cells
    By merrin84 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-22-2015, 05:08 PM
  3. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  4. Replies: 6
    Last Post: 05-06-2010, 10:06 PM
  5. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 AM

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