Round a number to the Nearest .25

=mround(a1,0.25)
needs analysis tool pak addin installed
or
take a look at CEILING and FLOOR functions in help

"Dave E" <Dave E@discussions.microsoft.com> wrote in message
news:80F14D4C-FFFE-4242-AE73-B05254911F07@microsoft.com...
>I am running a perpetual inventory book that tracks consumption of small
> parts by installation technicians. It tracks direct weekly consumption
> through most of the month but for the last week of the month it estimates
> that weeks consumption based on the average weekly consumption for the
> rest
> of the month. The numbers may sometimes be a mix of -, + numbers. I need
> it
> to round this estimation to the nearest 1/4 because some of the parts are
> inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can
> get
> my numbers to round to the next 10th or 100th but I need them in 1/4
> increments (ie-.25, .50. .70, 1).
> Any help or suggestions would be greatly appreciated.
> Dave

On Wed, 29 Jun 2005 07:03:08 -0700, Dave E <Dave E@discussions.microsoft.com>
wrote:

>I am running a perpetual inventory book that tracks consumption of small
>parts by installation technicians. It tracks direct weekly consumption
>through most of the month but for the last week of the month it estimates
>that weeks consumption based on the average weekly consumption for the rest
>of the month. The numbers may sometimes be a mix of -, + numbers. I need it
>to round this estimation to the nearest 1/4 because some of the parts are
>inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can get
>my numbers to round to the next 10th or 100th but I need them in 1/4
>increments (ie-.25, .50. .70, 1).
>Any help or suggestions would be greatly appreciated.
>Dave


=ROUND(num*4,0)/4


--ron

=mround(a1,0.25)
needs analysis tool pak addin installed
or
take a look at CEILING and FLOOR functions in help

"Dave E" <Dave E@discussions.microsoft.com> wrote in message
news:80F14D4C-FFFE-4242-AE73-B05254911F07@microsoft.com...
>I am running a perpetual inventory book that tracks consumption of small
> parts by installation technicians. It tracks direct weekly consumption
> through most of the month but for the last week of the month it estimates
> that weeks consumption based on the average weekly consumption for the
> rest
> of the month. The numbers may sometimes be a mix of -, + numbers. I need
> it
> to round this estimation to the nearest 1/4 because some of the parts are
> inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can
> get
> my numbers to round to the next 10th or 100th but I need them in 1/4
> increments (ie-.25, .50. .70, 1).
> Any help or suggestions would be greatly appreciated.
> Dave

On Wed, 29 Jun 2005 07:03:08 -0700, Dave E <Dave E@discussions.microsoft.com>
wrote:

>I am running a perpetual inventory book that tracks consumption of small
>parts by installation technicians. It tracks direct weekly consumption
>through most of the month but for the last week of the month it estimates
>that weeks consumption based on the average weekly consumption for the rest
>of the month. The numbers may sometimes be a mix of -, + numbers. I need it
>to round this estimation to the nearest 1/4 because some of the parts are
>inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can get
>my numbers to round to the next 10th or 100th but I need them in 1/4
>increments (ie-.25, .50. .70, 1).
>Any help or suggestions would be greatly appreciated.
>Dave


=ROUND(num*4,0)/4


--ron

I am running a perpetual inventory book that tracks consumption of small
parts by installation technicians. It tracks direct weekly consumption
through most of the month but for the last week of the month it estimates
that weeks consumption based on the average weekly consumption for the rest
of the month. The numbers may sometimes be a mix of -, + numbers. I need it
to round this estimation to the nearest 1/4 because some of the parts are
inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can get
my numbers to round to the next 10th or 100th but I need them in 1/4
increments (ie-.25, .50. .70, 1).
Any help or suggestions would be greatly appreciated.
Dave

=mround(a1,0.25)
needs analysis tool pak addin installed
or
take a look at CEILING and FLOOR functions in help

"Dave E" <Dave E@discussions.microsoft.com> wrote in message
news:80F14D4C-FFFE-4242-AE73-B05254911F07@microsoft.com...
>I am running a perpetual inventory book that tracks consumption of small
> parts by installation technicians. It tracks direct weekly consumption
> through most of the month but for the last week of the month it estimates
> that weeks consumption based on the average weekly consumption for the
> rest
> of the month. The numbers may sometimes be a mix of -, + numbers. I need
> it
> to round this estimation to the nearest 1/4 because some of the parts are
> inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can
> get
> my numbers to round to the next 10th or 100th but I need them in 1/4
> increments (ie-.25, .50. .70, 1).
> Any help or suggestions would be greatly appreciated.
> Dave

On Wed, 29 Jun 2005 07:03:08 -0700, Dave E <Dave E@discussions.microsoft.com>
wrote:

>I am running a perpetual inventory book that tracks consumption of small
>parts by installation technicians. It tracks direct weekly consumption
>through most of the month but for the last week of the month it estimates
>that weeks consumption based on the average weekly consumption for the rest
>of the month. The numbers may sometimes be a mix of -, + numbers. I need it
>to round this estimation to the nearest 1/4 because some of the parts are
>inventoried by the bag(bag of 100 parts)and are counted by 1/4's. I can get
>my numbers to round to the next 10th or 100th but I need them in 1/4
>increments (ie-.25, .50. .70, 1).
>Any help or suggestions would be greatly appreciated.
>Dave


=ROUND(num*4,0)/4


--ron