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?