I am working with currency figures and require each total to roundup to the
nearest .9 if the figure is for example 10.68 and to rounddown to the nearest
..9 IF it is less than .5 (for example 10.49).

I have tried various functions, including ROUNDUP/ROUNDDOWN but with no
success unless it is to an integer.

=ROUND(A2,0)-0.1

HTH,
Bernie
MS Excel MVP


"Office Buddy" <Office wrote in message
...
I am working with currency figures and require each total to roundup to the
nearest .9 if the figure is for example 10.68 and to rounddown to the nearest
.9 IF it is less than .5 (for example 10.49).

I have tried various functions, including ROUNDUP/ROUNDDOWN but with no
success unless it is to an integer.

Try
=ROUND(A1/0.5,0)*0.5-0.01

If this post helps click Yes
---------------
Jacob Skaria


"Office Buddy" wrote:

I am working with currency figures and require each total to roundup to the
nearest .9 if the figure is for example 10.68 and to rounddown to the nearest
.9 IF it is less than .5 (for example 10.49).

I have tried various functions, including ROUNDUP/ROUNDDOWN but with no
success unless it is to an integer.

Office Buddy wrote:
I am working with currency figures and require each total to roundup to the
nearest .9 if the figure is for example 10.68 and to rounddown to the nearest
.9 IF it is less than .5 (for example 10.49).

I have tried various functions, including ROUNDUP/ROUNDDOWN but with no
success unless it is to an integer.

Does this work for you?

=ROUND(A1,0)-.1