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?