Conditional Rounding

[MrHoohah]

Greetings!

I have a quick query about rounding. I know one way of doing this involves IF, but I was wondering if there was some combination of ROUND/MROUND/CEILING/FLOOR/(any other rounding function I don't know about) to achieve the same results without the use of an IF.

The software my workplace uses rounds decimals >=.49 up to the next whole number, whereas Excel does the normal thing and rounds down. I feed data to the software in the form of spreadsheets, and every now and then, one of these goofs (nicknamed "Woody's RoundUp" by a coworker) rears its ugly head and it's, as you can guess, a bit annoying.

Like I said, I know how to do it with IF, so this is really more of a curiosity than anything; I like learning about alternate methods. Thanks for your time!

EDIT: Just realized I didn't even really clarify this - The software is what the company considers "correct", so the Excel sheet needs to match up with it for the testing to go smoothly.

[daddylonglegs]

Hello MrHoohah,

I'm not clear how the rounding should work, can you clarify?

ROUND function in Excel always rounds to the nearest value, e.g.

=ROUND(8.4,0) = 8

but

=ROUND(8.6,0) = 9

Exactly halfway rounds up, i.e.

=ROUND(8.5,0) = 9

How does your software differ?

[MrHoohah]

Yep, Excel rounds the correct way, and the software rounds in a silly way. Here's how it would look if Excel did it the same way our software does it:

=ROUND(8.4, 0) = 8 -Same as Excel
=ROUND(8.5,0) = 9 -Same as Excel
=ROUND(8.49,0) = 9 -Silly.

What we've been using is this:
=IF(A2-INT(A2)>=.49, ROUNDUP(A2, 0), ROUND(A2, 0)

[popipipo]

=ROUND(A1+0,01;0)
try this

[minnesotaart]

Wouldn't ROUND work just fine if you added .01 to your number?

[daddylonglegs]

That works for me popipipo....or you can use this one

=INT(A2+0.51)

[MrHoohah]

It's possible that those work, I'll have to try them out on a few sheets. It's just that every number gets thrown around and put through so many other formulas, adding a .01 to everything might throw something else off. However, that is a ridiculously simple quick fix for the columns that -do- throw a fit; I have really, really been overthinking it, lol!

Thanks a lot for the suggestions, everyone!