Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 30

Thread: Round Up To Nearest X`

  1. #1
    Join Date
    9th June 2007
    Posts
    9

    Round Up To Nearest X`

    Hello. First post here. I trying to make a formula that will multiply a cell by 1.43 and then round the total up to the nearest 45 or 95 with no decimal points. Any help would be greatly appreciated.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Round Up To Nearest 45 Or 95

    Try something like this to round up the value in cell B1:

    =ROUNDUP((B1*1.43)/45,0)*45

    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    9th June 2007
    Posts
    9

    Re: Round Up To Nearest 45 Or 95

    That doesn't seem to be working. It just rounds it to the nearest multiple of ten. I think i'm a little further along now though. This will round to 95 everytime...
    =ROUNDUP((C2*1.25),-2)-5
    Now I just need to find out how to add the round to 45 in there.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    8th December 2006
    Location
    New Zealand
    Posts
    4,284

    Re: Round Up To Nearest 45 Or 95

    Datzneat,

    Please do not add code tags to formulas. You can if you like add formula tags like this (new feature of website:

    [f]=roundup (c2, -2) -5[/f]

    gives


    Try this formula. Column letter & Row number are for example only. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas
     Z
    100 =roundup (c2, -2) -5 

    Last edited by Reafidy; June 9th, 2007 at 11:41.

  5. #5
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Round Up To Nearest 45 Or 95

    I attached a sample of the formula I posted and it seems to work. Unless, I don't understand what you want...

    Jim
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,329

    Re: Round Up To Nearest 45 Or 95

    = Min( Roundup( A1 * 1.43 / 45, 0) * 45, Roundup( A1 * 1.43 / 95, 0) * 95)
    Entia non sunt multiplicanda sine necessitate.

  7. #7
    Join Date
    9th June 2007
    Posts
    9

    Re: Round Up To Nearest 45 Or 95

    Yea i'm still seeing the wrong numbers with these. It should only be coming up with numbers that end in 45 or 95.
    ie.
    11 would be 45
    32 would be 45

    46 would be 95
    1865 would be 1895

    and so forth.

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Round Up To Nearest 45 Or 95

    See if this gets us any closer.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,329

    Re: Round Up To Nearest 45 Or 95

    Quote Originally Posted by datzneat
    11 would be 45
    32 would be 45
    46 would be 95
    1865 would be 1895
    That's incorrect.

    11 * 1.43 = 15.73, rounded up to multiple of 45 is 45, to 95 is 95, smaller is 45
    32 * 1.43 = 45.76, rounded up to multiple of 45 is 90, to 95 is 95, smaller is 90
    46 * 1.43 = 65.78, rounded up to multiple of 45 is 90, to 95 is 95, smaller is 90
    1896 * 1.43 = 2711.28, rounded up to multiple of 45 is 2745, to 95 is 2755, smaller is 2745
    Last edited by shg; June 9th, 2007 at 12:18.
    Entia non sunt multiplicanda sine necessitate.

  10. #10
    Join Date
    9th June 2007
    Posts
    9

    Re: Round Up To Nearest 45 Or 95

    I don't get what you're saying shg... those were just examples of what i need the numbers to round to, all multiplying aside.

    The problem with that code Jim is that it isn't just one code. It is multiple codes, and i'm not sure if rounddown is the best way to do it...

    Is there a way to work an OR statement into : =ROUNDUP((C2*1.25),-2)-5

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Round up to nearest 50?
    By DANDERSON in forum Excel General
    Replies: 4
    Last Post: March 16th, 2017, 13:36
  2. Round Up To Nearest X
    By Andy Wild in forum Excel General
    Replies: 1
    Last Post: August 9th, 2008, 01:53
  3. Round To Nearest Quarter
    By WB SA!LOR in forum Excel General
    Replies: 2
    Last Post: April 18th, 2008, 23:47
  4. Round To Nearest Multiple
    By Jodi R in forum Excel General
    Replies: 1
    Last Post: October 11th, 2007, 13:07
  5. Round numbers to nearest 5
    By darkwalk in forum Excel General
    Replies: 6
    Last Post: June 21st, 2005, 16:54

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
  •  
porno