(Msg. 1) Posted: Tue Nov 17, 2009 9:31 am
Post subject: How do I roundup to .9 and rounddown to .9 Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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.
(Msg. 2) Posted: Tue Nov 17, 2009 9:46 am
Post subject: RE: How do I roundup to .9 and rounddown to .9 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 3) Posted: Tue Nov 17, 2009 11:46 am
Post subject: Re: How do I roundup to .9 and rounddown to .9 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 4) Posted: Tue Nov 17, 2009 12:45 pm
Post subject: Re: How do I roundup to .9 and rounddown to .9 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=ROUND(A2,0)-0.1
HTH,
Bernie
MS Excel MVP
"Office Buddy" <Office Buddy RemoveThis @discussions.microsoft.com> wrote in message
news:11309675-8465-435C-87C5-D9C2344F9A81@microsoft.com...
>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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office