+ Reply to Thread
Results 1 to 2 of 2

Mround

  1. #1
    ynissel
    Guest

    Mround

    I want to round to the 1/8, is there are way to do it which always goes to
    the highest 1/8 as opposed to closest 1/8 ?
    Thanks

  2. #2
    JE McGimpsey
    Guest

    Re: Mround

    One way:

    =CEILING(A1, 0.125)

    In article <[email protected]>,
    "ynissel" <[email protected]> wrote:

    > I want to round to the 1/8, is there are way to do it which always goes to
    > the highest 1/8 as opposed to closest 1/8 ?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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