Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 6 of 6
  1. 05-16-2009 10:13 PM #1
    jlute@marzetti.com Guest

    Default ROUNDUP to nearest 1/16 (in decimals)

    How can I ROUNDUP a number to the nearest 1/16? I currently have a
    column with 1/16 increments listed in decimals:
    1/16 = 0.0625
    1/8 = 0.125
    3/16 = 0.1875
    etc.

    Do I simply do a lookup on that column? If so, how can I do this?

    THANKS!
    Reply With Quote Reply With Quote  
  2. 05-16-2009 10:13 PM #2
    Bernd P Guest

    Default Re: ROUNDUP to nearest 1/16 (in decimals)

    =ROUNDUP(A2*16,0)/16
    will round UP to next 1/16. Take ROUND if you want to round to closest
    1/16.

    Regards,
    Bernd
    Reply With Quote Reply With Quote  
  3. 05-16-2009 10:13 PM #3
    jlute@marzetti.com Guest

    Default Re: ROUNDUP to nearest 1/16 (in decimals)

    On May 12, 9:34*am, Bernd P <bplumh...@gmail.com> wrote:
    > =ROUNDUP(A2*16,0)/16
    > will round UP to next 1/16. Take ROUND if you want to round to closest
    > 1/16.
    >
    > Regards,
    > Bernd

    Thanks, Bernd. I should've been more specific. I need to round the
    result of the following function to the nearest 1/16:
    =(V5*D5)-AB12+AC12

    How can I modify this to round accordingly?
    Reply With Quote Reply With Quote  
  4. 05-16-2009 10:13 PM #4
    Glenn Guest

    Default Re: ROUNDUP to nearest 1/16 (in decimals)

    jlute@marzetti.com wrote:
    > On May 12, 9:34 am, Bernd P <bplumh...@gmail.com> wrote:
    >> =ROUNDUP(A2*16,0)/16
    >> will round UP to next 1/16. Take ROUND if you want to round to closest
    >> 1/16.
    >>
    >> Regards,
    >> Bernd
    >
    > Thanks, Bernd. I should've been more specific. I need to round the
    > result of the following function to the nearest 1/16:
    > =(V5*D5)-AB12+AC12
    >
    > How can I modify this to round accordingly?


    Substitute your function for A2 in Bernd's function.


    =ROUNDUP(((V5*D5)-AB12+AC12)*16,0)/16
    Reply With Quote Reply With Quote  
  5. 05-16-2009 10:13 PM #5
    jlute@marzetti.com Guest

    Default Re: ROUNDUP to nearest 1/16 (in decimals)

    On May 12, 9:55*am, Glenn <addr...@not.valid> wrote:
    > jl...@marzetti.com wrote:
    > > On May 12, 9:34 am, Bernd P <bplumh...@gmail.com> wrote:
    > >> =ROUNDUP(A2*16,0)/16
    > >> will round UP to next 1/16. Take ROUND if you want to round to closest
    > >> 1/16.
    >
    > >> Regards,
    > >> Bernd
    >
    > > Thanks, Bernd. I should've been more specific. I need to round the
    > > result of the following function to the nearest 1/16:
    > > =(V5*D5)-AB12+AC12
    >
    > > How can I modify this to round accordingly?
    >
    > Substitute your function for A2 in Bernd's function.
    >
    > =ROUNDUP(((V5*D5)-AB12+AC12)*16,0)/16

    Good grief! Thanks, Glenn! I was going about this the hard way!
    Thanks, Bernd!
    Reply With Quote Reply With Quote  
  6. 05-16-2009 10:13 PM #6
    David Biddulph Guest

    Default Re: ROUNDUP to nearest 1/16 (in decimals)

    =CEILING((V5*D5)-AB12+AC12,1/16)
    --
    David Biddulph

    <jlute@marzetti.com> wrote in message
    news:0c0975d3-605e-4931-a331-b7ff955a65b7@x6g2000vbg.googlegroups.com...
    > On May 12, 9:34 am, Bernd P <bplumh...@gmail.com> wrote:
    > > =ROUNDUP(A2*16,0)/16
    > > will round UP to next 1/16. Take ROUND if you want to round to closest
    > > 1/16.
    > >
    > > Regards,
    > > Bernd

    > Thanks, Bernd. I should've been more specific. I need to round the
    > result of the following function to the nearest 1/16:
    > =(V5*D5)-AB12+AC12
    >
    > How can I modify this to round accordingly?


    Reply With Quote Reply With Quote  
« Previous Thread | Next 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

Forum Rules