+ Reply to Thread
Results 1 to 3 of 3

Min & Max combined formula

  1. 11-27-2014, 10:48 PM #1
    husni
    husni is offline
    Registered User
    Join Date
    02-18-2014
    Location
    Ampang, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    35

    Min & Max combined formula

    Dear All,

    Please help me with this MIN & MAX combination formula.

    MIN(30,D8+D23+D29+D47)
    MAX(0,D8+D23+D29+D47)

    Please help me.....

    Thanks
    Reply With QuoteRegister To Reply
  2. 11-27-2014, 11:19 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Min & Max combined formula

    Try this:
    Please Login or Register  to view this content.
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 11-28-2014, 12:26 AM #3
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918

    Re: Min & Max combined formula

    Welcome to the Forum, unfortunately:

    This is a duplicate post http://www.excelforum.com/excel-form...d-formula.html
    Ben Van Johnson
    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. [SOLVED] Min & Max combined formula
    By husni in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-28-2014, 12:24 AM
  2. [SOLVED] Combined 'and', 'if' and 'or' formula
    By jessiebelle1980 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 06:25 AM
  3. [SOLVED] need a combined formula
    By moin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2013, 11:33 PM
  4. MIN And MAX Combined Formula
    By Delta88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2008, 03:16 PM
  5. [SOLVED] IF and MAX combined formula
    By holyman in forum Excel General
    Replies: 6
    Last Post: 06-30-2006, 08:40 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