Results 1 to 5 of 5

Set Minimum for Round Function outcome

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    Zimbabwe
    MS-Off Ver
    Microsoft Office 365
    Posts
    2

    Set Minimum for Round Function outcome

    Hello Everybody,

    This is my first post in this forum,

    I hope everybody is doing well

    I have a small problem,

    I am trying to set the minimum outcome for this "=ROUND(F2/250,0)" to be 1 and not 0 whenever I enter a number less than 125 in the F2 cell.

    Thank you!
    Last edited by AJ86; 01-18-2016 at 01:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I get a specific outcome from a function?
    By Platerising in forum Excel General
    Replies: 7
    Last Post: 01-12-2016, 05:29 PM
  2. [SOLVED] If function, many ifs but one or two outcome?
    By axangec in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2016, 06:14 AM
  3. Multipy by percentage and round up by a minimum of 2 digits if less than 2.
    By lgcarpenter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2014, 03:25 PM
  4. [SOLVED] outcome of CONCATENATE function
    By clareleeder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2013, 01:17 PM
  5. Using ROUNDUP and a Minimum value (that doesn't round) in the same function.
    By Stahlfeder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2012, 06:43 PM
  6. Round total time to 1 hour multiples with a minimum of two
    By 2funny4words in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-06-2009, 03:02 PM
  7. VB Function Round vs Excel function Round not behaving the same Od
    By Bud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2006, 12:45 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