Rounding
 

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?

Rounding
 

=ROUND(A1*40%,-2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Junior" wrote in message ...
|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?

Rounding
 

try
=round(num*0.4,-2)

"Junior" wrote:

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?

Rounding
 

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.

"Niek Otten" wrote:

=ROUND(A1*40%,-2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Junior" wrote in message ...
|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?

Rounding
 

Use ROUNDUP function.

Same formula.


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 09:51:01 -0700, Junior
wrote:

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.

"Niek Otten" wrote:

=ROUND(A1*40%,-2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Junior" wrote in message ...
|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?

Rounding
 

Try this:

=CEILING(8700*0.4,100)


"Junior" wrote:

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?

Rounding
 

=CEILING(A1,100)

--
HTH

Bob Phillips

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

"Junior" wrote in message
...
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.

"Niek Otten" wrote:

=ROUND(A1*40%,-2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Junior" wrote in message
...
|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?