How do I round Up to the nearest hundred?

[Guest]

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)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanks

Got your reply after I posted the last query

 

[DaveMoore]

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

I am creating a rater and need to add two figures together, round up to

nearest hundred and calc by 11%.

 

[Harald Staff]

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

HTH. Best wishes Harald

I am creating a rater and need to add two figures together, round up to

nearest hundred and calc by 11%.

 

[Biju V]

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



All assistance appreciated

 

[Glenn]

This figure 1,235,256 to be shown as 1.2



All assistance appreciated

Custom number format:

#.#,,