+ Reply to Thread
Results 1 to 2 of 2

If condition function

  1. 03-24-2019, 05:32 PM #1
    thiyag
    thiyag is offline
    Registered User
    Join Date
    03-24-2019
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    10

    If condition function

    Hi, Can you please help me on this condition


    Below are the conditions looking for and the attached image will give more insight
    Conditions:

    Text should be Apple
    Options should be Either AA or BB
    If the above condtion met then add 1.1 to the Source
    Then Min (Source, (Value1, Value3)

    Excel Function.JPG
    Attached Images Attached Images
    Last edited by thiyag; 03-24-2019 at 05:33 PM. Reason: Updated the image
    Reply With QuoteRegister To Reply
  2. 03-26-2019, 10:48 AM #2
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,544

    Re: If condition function

    Contributors be aware that this question has been asked and a proposed solution offered in another thread.
    https://www.excelforum.com/excel-new...ml#post5089401
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. Search for text in First set e.g Apple and Min value from the corresponding set
    By thiyag in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 04-12-2019, 09:37 AM
  2. [SOLVED] MAX function + condition
    By Spikyd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2017, 08:20 AM
  3. [SOLVED] Sum function with a condition
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2016, 03:49 PM
  4. How to if function for between condition
    By Terressa in forum Excel General
    Replies: 3
    Last Post: 07-01-2015, 05:55 AM
  5. If condition function need help
    By kishoremcp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2013, 07:32 AM
  6. [SOLVED] Can I add an 'or' condition to the COUNTIF function? If not, what other function can I use
    By newbie0101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2012, 01:41 AM
  7. Many Condition with IF Function
    By Aumkar in forum Excel General
    Replies: 10
    Last Post: 07-30-2010, 08:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1