Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Round Up To Nearest X`

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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

    Comment


    • #3
      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.

      Comment


      • #4
        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, 11:41.
        Reafidy

        Forum Rules | Anatomy Of A Good Thread Title | What Have You Tried So Far? | Are You A Cross Poster?

        Comment


        • #5
          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

          Comment


          • #6
            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.

            Comment


            • #7
              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.

              Comment


              • #8
                Re: Round Up To Nearest 45 Or 95

                See if this gets us any closer.
                Attached Files

                Comment


                • #9
                  Re: Round Up To Nearest 45 Or 95

                  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, 12:18.
                  Entia non sunt multiplicanda sine necessitate.

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Re: Round Up To Nearest 45 Or 95

                      Hi shg,

                      I think OP is still struggling with how to say what they want. I don't think they meant a "multiple", just something else.

                      Jim

                      Comment


                      • #12
                        Re: Round Up To Nearest 45 Or 95

                        Datzneat, is what you mean that the number * 1.43 should be rounded up to the nearest number ending in 45 or 95?
                        Entia non sunt multiplicanda sine necessitate.

                        Comment


                        • #13
                          Re: Round Up To Nearest 45 Or 95

                          That is correct sir. Sorry if i sound like a bumbling idiot on here lol.

                          Comment


                          • #14
                            Re: Round Up To Nearest 45 Or 95

                            Hi,

                            =CEILING(A1*1.43+5,50)-5

                            HTH
                            Kris

                            ExcelFox

                            Comment


                            • #15
                              Re: Round Up To Nearest 45 Or 95

                              One more...
                              Attached Files

                              Comment

                              Trending

                              Collapse

                              There are no results that meet this criteria.

                              Working...
                              X