• How do I round Up to the nearest hundred?

    From christian.kuzdub@gmail.com@21:1/5 to christi...@gmail.com on Wed Mar 25 16:35:57 2020
    On Wednesday, March 25, 2020 at 6:33:49 PM UTC-5, christi...@gmail.com wrote:
    On Friday, July 2, 2004 at 12:42:01 AM UTC-5, aceirm wrote:
    I am creating a rater and need to add two figures together, round up to nearest hundred and calc by 11%.

    Step 1 Sum (A1:B1)
    Step 2 Round up (so if answer to step one is 962, I need result here to be 1,000)
    Step 3 multiple by 11%

    Steps 1 and 3 cause no issues but I am getting totally lost with the rounding.

    I'm not phased as to whether I can do this either in one formula or need 3.

    All assistance appreciated

    [SOLVED] I figured out how to round up to anything (nearest 100, 1000, etc.)

    Here's the formula:

    =(round((FORMULA TO ROUND)/1000))*1000

    Where it says "FORMULA TO ROUND", input the equation that needs rounding. In both spots it says "1000", input whatever you're rounding to. In this case "1000" represents rounding up to the nearest 1000.

    How that helps!

    Just found an even simpler solution here: https://www.lifewire.com/round-numbers-up-or-down-nearest-5-or-10-3123755

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From christian.kuzdub@gmail.com@21:1/5 to aceirm on Wed Mar 25 16:33:45 2020
    On Friday, July 2, 2004 at 12:42:01 AM UTC-5, aceirm wrote:
    I am creating a rater and need to add two figures together, round up to nearest hundred and calc by 11%.

    Step 1 Sum (A1:B1)
    Step 2 Round up (so if answer to step one is 962, I need result here to be 1,000)
    Step 3 multiple by 11%

    Steps 1 and 3 cause no issues but I am getting totally lost with the rounding.

    I'm not phased as to whether I can do this either in one formula or need 3.

    All assistance appreciated

    [SOLVED] I figured out how to round up to anything (nearest 100, 1000, etc.)

    Here's the formula:

    =(round((FORMULA TO ROUND)/1000))*1000

    Where it says "FORMULA TO ROUND", input the equation that needs rounding. In both spots it says "1000", input whatever you're rounding to. In this case "1000" represents rounding up to the nearest 1000.

    How that helps!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)