Rounding

[Guest]

I am looking to create a formula that will multiply one cell by 40% and then
round that number to the nearest hundred. For example, take 8700 and
mulitply it by 40% to get 3,480. I need to round that number up to 3,500.
Any suggestions?

 

[Niek Otten]

=ROUND(A1*40%,-2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am looking to create a formula that will multiply one cell by 40% and then
| round that number to the nearest hundred. For example, take 8700 and
| mulitply it by 40% to get 3,480. I need to round that number up to 3,500.
| Any suggestions?

 

[Guest]

try
=round(num*0.4,-2)

 

[Guest]

Thanks for the formula. However, when I use that it rounds up and down. I
need something that will only round up, 2,101 becomes 2,200.

 

[Gord Dibben]

Use ROUNDUP function.

Same formula.


Gord Dibben MS Excel MVP

 

[Guest]

Try this:

=CEILING(8700*0.4,100)

 

[Bob Phillips]

=CEILING(A1,100)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)