+ Reply to Thread
Results 1 to 4 of 4

Min - If function with multiple conditions results in Zero

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Question Min - If function with multiple conditions results in Zero

    Please see attached excel where I am trying to calculate the Minimum number in Column A, where the rows match multiple conditions.

    I am getting a zero as a result whereas the expected result should be from Cell A15

    Appreciate any Help.
    Attached Files Attached Files
    Last edited by ibuhary; 04-19-2018 at 02:13 AM. Reason: SOLVED

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Min - If function with multiple conditions results in Zero

    Give this try

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



    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: Min - If function with multiple conditions results in Zero

    I dont have any Zero data in Column A, in that case I hope I can avoid *(A2:A25>0) this part from the function.

    Please correct me if I am wrong.

    AND could you please tell me why it was not working with the AND condition, as I was under the impression "AND" & * refer to the same logic in Excel.
    Last edited by ibuhary; 04-19-2018 at 02:01 AM.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Min - If function with multiple conditions results in Zero

    Absolutely correct you can, I just added to avoid if there is any cell having 0 value.

+ 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. IF Statement with Multiple Conditions and Multiple True/False Results
    By ellesutgr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2015, 04:51 PM
  2. Replies: 3
    Last Post: 10-19-2014, 09:43 PM
  3. Replies: 1
    Last Post: 09-02-2014, 03:22 PM
  4. Multiple IF, vlookup conditions and varying results
    By dh1231 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2014, 12:14 PM
  5. [SOLVED] Average results based on multiple conditions and by month
    By Tanya_ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2013, 06:41 PM
  6. one formula wiht multiple conditions and results..
    By Pavan Shetty in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-13-2012, 04:48 AM
  7. [SOLVED] Returning only unique results based on multiple conditions
    By Dickens153 in forum Excel General
    Replies: 5
    Last Post: 03-29-2012, 12:29 PM

Tags for this Thread

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