Results 1 to 6 of 6

Formula to round up only when decimal value is .83 or greater

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    West Virginia
    MS-Off Ver
    Office 2003
    Posts
    2

    Formula to round up only when decimal value is .83 or greater

    I need calculations only in whole values. The whole value needs to round up only when the decimal value is .83 or greater. If decimal value is .82 or less it remains at current whole number.
    Last edited by RustyW; 11-20-2014 at 10:20 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel less and greater than, with round down results
    By Daysman in forum Excel General
    Replies: 4
    Last Post: 02-11-2014, 01:36 AM
  2. Replies: 1
    Last Post: 01-14-2014, 07:39 AM
  3. [SOLVED] round up to one decimal
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 07:17 AM
  4. Numbers round down when a 5 is in the third decimal place using a formula
    By Jbagger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2007, 11:59 AM
  5. Round X.50 and less down, X.51 and greater up
    By BigDave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2006, 04:10 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