=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?