How do I roundup to .9 and rounddown to .9

O

Office Buddy

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.
 
G

Glenn

Office said:
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.
Click to expand...

Does this work for you?

=ROUND(A1,0)-.1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi 2
How do I round last number without a decimal point 1
Need help with formula 3
How to stop Excel from rounding a number? 3
Rounding number to closest 50 or 100 on exel 1
RoundUp to the next multiple of .5 21
nested IF w/ LEN and ROUNDUP?? 5
How do I get price calculations to always end in 9? 5

Top