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

B

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
 
P

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
 
Top