+ Reply to Thread
Results 1 to 3 of 3

Min Function

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Unhappy Min Function

    Hello I am struggling to understand what the function below is saying if anyone could translate please? I understand the Min function takes a set of numbers and give the least value and the sum function add a set of numbers and multiplication well we all know what that means but I am not understanding the function below could someone explain to me please I am not sure why there is a parenthesis around one number and is it multiplying first one cell ?? or ???? not sure any help i would greatly appreciated please

    =MIN($C18,$B$11*($B18)*$R18)

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Min Function

    The smallest of two values, x and y.

    In your formula, x = C18, y = B11*B18*R18.

    Whichever of those is smallest, is the answer you'll get.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    07-06-2015
    Location
    Phoenix , AZ
    MS-Off Ver
    2010
    Posts
    47

    Re: Min Function

    Thank you so much!! I understand now life saver!!!

+ 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. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  2. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  3. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  4. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  5. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. [SOLVED] Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 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