+ Reply to Thread
Results 1 to 4 of 4

Minimum value of 5 in cell A32

  1. 08-01-2019, 10:31 AM #1
    i.r.smith
    i.r.smith is offline
    Registered User
    Join Date
    03-04-2013
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    39

    Minimum value of 5 in cell A32

    I'm having trouble getting cell A32 to display a minimum value of 5




    Thanks for your help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-01-2019, 10:35 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,076

    Re: Minimum value of 5 in cell A32

    How about
    =MAX(ROUNDUP((E29+F29)/6,0),5)
    Reply With QuoteRegister To Reply
  3. 08-01-2019, 10:39 AM #3
    i.r.smith
    i.r.smith is offline
    Registered User
    Join Date
    03-04-2013
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    39

    Re: Minimum value of 5 in cell A32

    Perfect. Thanks
    Reply With QuoteRegister To Reply
  4. 08-01-2019, 10:43 AM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,076

    Re: Minimum value of 5 in cell A32

    You're welcome & thanks for the feedback
    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] array minimum date if text from one cell is found in another cell
    By sinkerballer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-26-2017, 02:45 PM
  2. Optimize quantity of cell (volume) until another cell (funds) reaches Minimum tolerance
    By ryanhardt in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-26-2016, 05:39 AM
  3. [SOLVED] Formula to return text if the cell next cell contains maximum or minimum number in a range
    By Chypp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2014, 03:46 AM
  4. Finding Minimum Value, Then locate Value to Immediate left of Cell where Minimum was Found
    By RocklyV in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-17-2013, 03:53 PM
  5. [SOLVED] activate the equation of a cell providing that another cell meets a minimum requirement
    By shauncoll in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-06-2012, 11:38 AM
  6. Conditional Format Cell w/ Minimum Difference from Reference Cell
    By aolim in forum Excel General
    Replies: 5
    Last Post: 02-04-2011, 04:48 PM
  7. Find minimum SUM if no minimum number in row
    By zbor in forum Excel General
    Replies: 9
    Last Post: 12-25-2009, 05:04 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