+ Reply to Thread
Results 1 to 2 of 2

rounding to next 12th

  1. #1
    Amie Barnes
    Guest

    rounding to next 12th

    Hi:

    I can't seem to locate the function that round a number in the next cell to
    the next number divisible by 12 (eg if 25 is typed into cell A1, the formula
    in A2 should come up with 36). It must always round up (not to the nearest).

    Thanks.

  2. #2
    JE McGimpsey
    Guest

    Re: rounding to next 12th

    one way:

    =CEILING(A1,12)

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

    > Hi:
    >
    > I can't seem to locate the function that round a number in the next cell to
    > the next number divisible by 12 (eg if 25 is typed into cell A1, the formula
    > in A2 should come up with 36). It must always round up (not to the nearest).
    >
    > Thanks.


+ 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