4th Digit Rounding

I have an excel sheet here at work that does figuring based on area of an object to come up with stress rates. The issue is that for some reason, even with MROUND, when the number falls on xxx5, it wants to round down to the ten and not up. So if the calc comes out to be 1445.1, MRound to 10 will put it at 1440, when it needs to round up, as that is what my machine is doing and my reports need to match the machine output.

To get area I am using this in E4 - =(((B4)/2)^2)*3.1416
B4 is my input diameter for the specimen.

This calcs my strength - =MROUND((B7)/E4,10)
Where B7 is input in Max Load and E4 is the above mentioned area, and 10 is obviously what I am wanting it to use for rounding. I just need it to stop rounding down when it lands on 5.

The current example is a Max load of 113410 with an area of 12.566 bringing the strength to an unrounded 9025.14722... that it is rounding down to 9020 instead of the desired rounding up to 9030.

I have searched quite a few places and I can't seem to find a precise means of fixing it. Ceiling and floor wont work, roundup isnt doing it for me so I come here for your help.

Thanks for any help, I hope I was clear and concise enough.

-Brandon

It returns 9025 even when I change it to a straight formula.

The exact return value when I change the formatting back to general from Number is 9024.859944

B7 is 113410 in this case, E4 is 12.566

Perhaps the issue is number formatting is dropping the x.xxx4 from the 12.5664 putting it under 9025 but the 9024.85 isnt rounding up to 9025 stopping the final rounding from being 9030?

Just as you posted that I figured it, I just needed a nudge in the right direction. The hidden 4th decimal place was throwing it all off.

Thank you both!