How do I round Up to the nearest hundred?

[aceirm]

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

[garfield-n-odie]

=0.11*(round(sum(a1:b1)/100,0)*100)

[garfield-n-odie]

Oops, make that =0.11*(roundup(sum(a1:b1)/100,0)*100)

[aceirm]

Thanks

That formula works great except when we need go up to the next thousand

eg. answer to sum(a1:b1) is $ 950 and round up is $ 1,000. It seems to then calc at $ 900

"garfield-n-odie" wrote:

> =0.11*(round100,0)*100)

[aceirm]

Thanks

Got your reply after I posted the last query

[DaveMoore]

try (ROUNDUP(SUM(A1:B1),-2)*0.11

"aceirm" <ace...@discussions.microsoft.com> wrote in message
news:D7D26B74-FD7D-431D...@microsoft.com...

[Harald Staff]

Try also
=CEILING(A1+B1,1000)
for rounding up to nearest 1000

HTH. Best wishes Harald

"aceirm" <ace...@discussions.microsoft.com> skrev i melding
news:D7D26B74-FD7D-431D...@microsoft.com...

[V@discussions.microsoft.com Biju V]

> for example
This figure 1,235,256 to be shown as 1.2

All assistance appreciated
>

[Glenn]

Custom number format:

#.#,,

[christia...@gmail.com]

[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!

[christia...@gmail.com]

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