From: Gord Dibben on
With Analysis Toolpak add-in loaded.

In an adjacent column enter.


Copy down.

If not the pattern you need, swap the ROUNDDOWN and ROUNDUP or rplace ISEVEN
with ISODD

Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 07:46:01 -0700, HunterX
<HunterX(a)> wrote:

>I haven't had any success in trying to do the following:
>I have a column of hours - all with .50 (such as 8.50, 7.50, 1.50, etc.)
>I am trying to program a routine to go down the column cell by cell and
>alternately round the first cell up to the nearest whole number, round the
>second cell down to the nearest whole number, round the third one up to the
>nearest whole number, etc.
>I appreciate any help with this. Thank you !!