+ Reply to Thread
Results 1 to 3 of 3

IF AND OR Function required

  1. 12-20-2014, 03:20 AM #1
    manisai
    manisai is offline
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    41

    IF AND OR Function required

    Hi,

    Can some one help me on this.

    Type ED\WED C\WH
    --------------------------------
    EXPORT WED C
    LOCAL ED C
    EXPORT WED C
    LOCAL ED C
    EXPORT WED C
    LOCAL ED W
    EXPORT WED W
    LOCAL WED W
    EXPORT WED W
    LOCAL WED W

    Condition
    if Type = Export and ED/WED = Wed and c/w = w then ER
    if Type = Local and ED/WED = Wed and c/w = w then FB
    else nil

    Thanks in Advance
    Manisai
    Reply With QuoteRegister To Reply
  2. 12-20-2014, 03:28 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: IF AND OR Function required


    A
    B
    C
    D
    1
    EXPORT
    WED
    W
    =IF(AND(B1="WED",C1="W"),IF(A1="Export","ER","FB"),"")
    2
    LOCAL
    WED
    W
    =IF(AND(B2="WED",C2="W"),IF(A2="Export","ER","FB"),"")
    3
    EXPORT
    WED
    W
    =IF(AND(B3="WED",C3="W"),IF(A3="Export","ER","FB"),"")
    4
    LOCAL
    WED
    W
    =IF(AND(B4="WED",C4="W"),IF(A4="Export","ER","FB"),"")




    A
    B
    C
    D
    1
    EXPORT
    WED
    W
    ER
    2
    LOCAL
    WED
    W
    FB
    3
    EXPORT
    WED
    W
    ER
    4
    LOCAL
    WED
    W
    FB


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 12-20-2014, 05:04 AM #3
    manisai
    manisai is offline
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    41

    Re: IF AND OR Function required

    Thanks it works
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If Function - Help required
    By Santhoshhrishi in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 11:48 AM
  2. IF Function - Help Required!
    By atkinsd91 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-05-2014, 07:53 PM
  3. Excel 2007 : what function do i use, help required.
    By fentiger79 in forum Excel General
    Replies: 1
    Last Post: 04-18-2012, 03:25 PM
  4. Function required...
    By Jitesh.Chheda in forum Excel General
    Replies: 2
    Last Post: 10-10-2009, 01:12 PM
  5. [SOLVED] Function Required
    By MichaelC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2005, 09:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1