+ Reply to Thread
Results 1 to 3 of 3

Formula to return specific text based on multiple cells meeting a single criteria

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Staffordshire
    MS-Off Ver
    Excel 2010
    Posts
    31

    Formula to return specific text based on multiple cells meeting a single criteria

    Hi,

    I need a formula that will return a specific text, based upon multiple cells meeting a single critera.

    In Cell F2 I need a formula that will return the result "Exception", when the information in cells B2, C2, D2 &
    E2 are all >= 5%, if they are less than this then it needs to leave the cell blank

    A B C D E F
    2 12% -1% -2% -9%
    3 14% -20% 6% -19%
    4 13% 6% -9% -11%
    5 -4% -6% -18% -14%
    6 -23% -7% 44% 28%

    Any assistance is greatly appreciated, I know it is probably very simple but am banging my head against the wall!

    Thanks,

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Formula to return specific text based on multiple cells meeting a single criteria

    Try:

    =IF(COUNTIF(B2:E2,">=0.05")=4,"Exception","")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    Staffordshire
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Formula to return specific text based on multiple cells meeting a single criteria


    Thank you so much, that works perfectly!

+ 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. [SOLVED] How to return multiple values to a single cell based on multiple criteria
    By lwallace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 06:32 AM
  2. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  3. Return Single Value Based on Multiple Criteria
    By grebgineok in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2010, 01:36 PM
  4. Replies: 4
    Last Post: 05-04-2010, 02:25 PM
  5. Replies: 3
    Last Post: 07-21-2009, 02:16 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