+ Reply to Thread
Results 1 to 2 of 2

Possible to round up and round down in the same formula?

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    26

    Possible to round up and round down in the same formula?

    I currently have a formula that nicely tidies up some prices for me. It rounds to the nearest .05 or .09, so for example 3.43 becomes 3.45 and 8.96 becomes 8.99. The only issue is that I want it to round down, only in the case that the figure just above a round number. So if it's 8.01, I'd like it to round down to 7.99 instead of round up to 8.05. I've attached a spreadsheet that shows my formula, and highlighted the cases that I want it to round down instead.

    Can this be done?

    Would really appreciate any help. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Possible to round up and round down in the same formula?

    The points of interest are equidistant from one another. How do you wish to round in the event of a tie?

    Your first figure is 4.22, which is both .23 from 3.99 and 4.45.

    I've got most of a function written for this but I'm not sure which way you'd like to go.

    =TwoPointsRound(a2,.99,.45)

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-30-2015, 11:34 AM
  2. Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  3. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  4. round up round down formula
    By m_789 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-04-2014, 05:34 AM
  5. [SOLVED] Conditional Round up or Round up Function
    By cdmterence in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-18-2013, 06:03 PM
  6. Counting to a specified numberin round, then add one to round
    By McG_84 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-10-2013, 04:20 PM
  7. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 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