Round up and down

[adrian]

Hi all

Can anyone tell me who to round up and down to the nearest
0.5 as result from an expression?

Say I end up with 2 figures 2.856 and 4.256

In this instance I would want the figures to result in

3.0 (rounded up) and 4.0 (rounded down).

I understand the ROUND function to set the number of
decimal places, but need it to the nearest 0.5

Thank you for any advice.

Regards
Adrian

 

[Word Heretic]

G'day "adrian" <[email protected]>,

Round(TestNumber * 2) /2

Hi all

Can anyone tell me who to round up and down to the nearest
0.5 as result from an expression?

Say I end up with 2 figures 2.856 and 4.256

In this instance I would want the figures to result in

3.0 (rounded up) and 4.0 (rounded down).

I understand the ROUND function to set the number of
decimal places, but need it to the nearest 0.5

Thank you for any advice.

Regards
Adrian

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email (e-mail address removed)
Products http://www.geocities.com/word_heretic/products.html

Replies offlist may require payment.