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

 

[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

 

[Guest]

Try this:

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

HTH,
Elkar