Round X.50 and less down, X.51 and greater up

[BigDave]

Is there a ROUND function that I can use that would round numbers ending in the following down?

.08
.17
.25
.33
.42
.50

Any other fraction greater than or equal to .51 would be rounded UP.

TIA

[Elkar]

Try this:

=IF(MOD(A1,1)>0.5,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

HTH,
Elkar

"BigDave" wrote:

>
> Is there a ROUND function that I can use that would round numbers ending
> in the following down?
>
> .08
> .17
> .25
> .33
> .42
> .50
>
> Any other fraction greater than or equal to .51 would be rounded UP.
>
> TIA
>
>
> --
> BigDave
> ------------------------------------------------------------------------
> BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741
> View this thread: http://www.excelforum.com/showthread...hreadid=498540
>
>

[Pete]

I'm a bit confused - is your list meant to be of decimals?

If so, you can use the ROUND( ) function to do this, by subtracting
0.01 from your number, e.g.:

=ROUND(your_number - 0.01,0)

I assume you want the numbers rounded to integers.

Pete