+ Reply to Thread
Results 1 to 4 of 4

Excel formula to meet the condition as required

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    Excel formula to meet the condition as required

    Please refer my attachment file.

    I am looking an excel formula who tell me the required result.

    Suppose,Cell C4,D4 and E4 having same text then,result should be as appear in cell G4 and G5.And if not,then,cell G6 and G7.

    Please suggest an excel formula,to solve the problem.
    Attached Files Attached Files
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,660

    Re: Excel formula to meet the condition as required

    Here, use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Excel formula to meet the condition as required

    OR,

    In G4:

    =IF(AND(C4=E4,D4=E4),C4,"Partially")

  4. #4
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    Re: Excel formula to meet the condition as required

    Thanks for the solution provide.

+ 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. A formula to count subtotals if they meet a qualifying condition
    By JC_LA_1979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2015, 01:03 PM
  2. [SOLVED] Required an excel formula to meet the multiple conditiond
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:30 AM
  3. [SOLVED] Formula required to meet returned Yes/No conditions
    By hammer2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-06-2013, 12:29 AM
  4. Replies: 2
    Last Post: 11-06-2012, 10:49 PM
  5. [SOLVED] Formula help required to enable conditional formatting of cells that meet multiple con
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2012, 10:10 AM
  6. [SOLVED] Formula help required to enable conditional formatting of cells that meet multiple cond.
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2012, 01:34 PM
  7. Formula Required For IF Condition
    By Reyan123 in forum Excel General
    Replies: 2
    Last Post: 03-09-2009, 03:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1