Thread
:
How do I roundup to .9 and rounddown to .9
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
external usenet poster
Posts: 5,441
How do I roundup to .9 and rounddown to .9
=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.
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick