+ Reply to Thread
Results 1 to 6 of 6

Simple If/Min Formula

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    31

    Simple If/Min Formula

    I have a if(min) formula.

    There are four (4) criteria

    Cell A1,B1,C1 & D1

    The formula looks at the data in each cell & gives the smallest amount

    This part is not the issue

    The formula is as follows:

    =Min(A1,B1,C1,D1)

    My question is as follows

    The current formula only works if there is data in all four (4) cells

    Is there a way to change the formula so that if one of the cells is 'blank',ignore that cell & give a result being the minimum of the remaining three (3) cells only?

    Thank you

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Simple If/Min Formula

    =MIN(IF(NOT(ISBLANK(A1:D1)),A1:D1)) as arrayformula

  3. #3
    Registered User
    Join Date
    05-05-2016
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    31
    Hello,

    Thank you

    What if the cells in question are not all in the same row?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,024

    Re: Simple If/Min Formula

    If the values were in A1, A2, B1 and B2 then the formula could be modified to read:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    05-05-2016
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    31
    Hello,
    I tried that formula but could not get it to work.

    Have attached the actual spreadsheet explaining the cells & calculations
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,895

    Re: Simple If/Min Formula

    Formula in G8 for F8=7 does not agree with your description

    IF($F8=7,MIN($G$2,$C8*$B8*$I$14)

    vs

    smallest amount of either, G2,D8*I14 or C8*E8.

+ 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. Simple Formula When Input for Formula is null
    By ulala2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-25-2017, 10:27 AM
  2. Simple V look up formula help!
    By Nutorious in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 08:09 AM
  3. Replies: 4
    Last Post: 12-07-2012, 11:49 AM
  4. Simple Formula
    By sparky180 in forum Excel General
    Replies: 3
    Last Post: 07-22-2011, 09:26 AM
  5. Need help with a simple formula
    By changetires in forum Excel General
    Replies: 6
    Last Post: 06-14-2006, 09:45 AM
  6. [SOLVED] simple formula
    By Brian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Help with what should be a simple formula
    By B Millar via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1