+ Reply to Thread
Results 1 to 2 of 2

Rounding a number to the nearest 1/3

  1. #1
    Registered User
    Join Date
    04-04-2009
    Location
    Nashville, TN,USA
    MS-Off Ver
    Excel 2007
    Posts
    87

    Rounding a number to the nearest 1/3

    Hello,
    I was wondering if someone could PLEASE HELP me with this problem I am having. I want to take a number in a certain cell and have that number rounded up to the nearest 1/3. EX

    Cell A1 comes to 25.06 I want to take that number to an order form that I have and it round up to 25.33

    OR

    42.72 Rounded up to 43 (42.99)
    and so on.

    Another thing to add to the frustration is that I want to do it with no VBA?
    Is this even possible?
    I am counting on all you geniuses to help me through this!

    Thank you!
    Last edited by NBVC; 09-23-2009 at 11:39 AM. Reason: Per Rep Comments

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Rounding a number to the nearest 1/3

    Try:

    =ceiling(a1,1/3)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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