+ Reply to Thread
Results 1 to 9 of 9

Min/Max Nested Excel Functions

  1. #1
    Registered User
    Join Date
    01-29-2021
    Location
    Spain
    MS-Off Ver
    MS Office 365 Excel for Mac (2021)
    Posts
    3

    Min/Max Nested Excel Functions

    I need to insert an unique formula
    Last edited by Rodger10; 02-05-2021 at 07:00 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Min/Max Nested Excel Functions

    Welcome to the forum.

    You seem to have forgotten to fill in some manually calculated results to show what you are aiming for.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-29-2021
    Location
    Spain
    MS-Off Ver
    MS Office 365 Excel for Mac (2021)
    Posts
    3

    Re: Min/Max Nested Excel Functions

    I need to insert an unique formula
    Last edited by Rodger10; 02-05-2021 at 06:55 AM.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Min/Max Nested Excel Functions

    Exactly. They are empty - no manually calculated results showing what you are aiming for.

  5. #5
    Registered User
    Join Date
    01-29-2021
    Location
    Spain
    MS-Off Ver
    MS Office 365 Excel for Mac (2021)
    Posts
    3

    Re: Min/Max Nested Excel Functions

    I need to insert an unique formula
    Last edited by Rodger10; 02-05-2021 at 06:54 AM.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,368

    Re: Min/Max Nested Excel Functions

    Your words and phrases make this appear to be a question you have been asked with a hint (or two) as to what the solution might involve.

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Min/Max Nested Excel Functions

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I will provide the link for you this time: https://www.mrexcel.com/board/thread...rmula.1160097/.)

    If you provide the level of detail here that you provided at Mr Excel, you will get help, but the attachment you have provided here does not contain that level of detail.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Min/Max Nested Excel Functions

    Not likely after so long, but thanks for offering.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,368

    Re: Min/Max Nested Excel Functions

    Definitely a homework question. IF solutions give the right answer but I want a nested MAX/MIN.

+ 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. Excel version 2002 Nested functions with if -- plus or \ and
    By PONY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2016, 12:31 PM
  2. Help With Nested IF Functions Excel 2010
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-24-2014, 02:17 PM
  3. [SOLVED] MS Excel: nested IF Functions in multiple sheets
    By erynatpitt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 06:20 AM
  4. Excel 2007 Nested IF Functions, please help!
    By Zulli85 in forum Excel General
    Replies: 4
    Last Post: 03-07-2011, 05:08 AM
  5. workaround for exceeding 7 nested functions in Excel?
    By marcia21 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-07-2008, 09:27 AM
  6. [SOLVED] nested if functions in Excel 2002
    By Darin Gibson in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-22-2005, 03:55 PM
  7. [SOLVED] ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS
    By Linda Bolton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2005, 08:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1