+ Reply to Thread
Results 1 to 2 of 2

Specific Rounding Function

  1. 12-07-2018, 06:24 AM #1
    BenjaminArnold
    BenjaminArnold is offline
    Registered User
    Join Date
    12-06-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    4

    Specific Rounding Function

    Hello,

    Want to create a formula which will always roundup to 10,000 unless it passes 10,000 in its result.

    Many thanks!
    Reply With QuoteRegister To Reply
  2. 12-07-2018, 06:29 AM #2
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,899

    Re: Specific Rounding Function



    =MAX(A1,10000)
    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. Rounding up to specific set of numbers.
    By theoudie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-10-2015, 10:14 PM
  2. Excel 2007 : rounding up values to a specific value
    By debbelles1 in forum Excel General
    Replies: 4
    Last Post: 04-03-2012, 09:56 AM
  3. Rounding up or down to a specific date
    By ajh19742000 in forum Excel General
    Replies: 6
    Last Post: 12-18-2011, 09:34 AM
  4. Excel 2007 : rounding off to a specific day
    By shadowplay in forum Excel General
    Replies: 3
    Last Post: 09-09-2010, 10:45 AM
  5. Rounding to specific values
    By culverd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2008, 05:05 PM
  6. Rounding up to a set of specific numbers?
    By bradles in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-08-2006, 02:20 PM
  7. Rounding to a specific value (up or down)
    By Dave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2006, 01:30 PM

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