From: Gord Dibben on 2 Jun 2010 11:55
With Analysis Toolpak add-in loaded.
In an adjacent column enter.
If not the pattern you need, swap the ROUNDDOWN and ROUNDUP or rplace ISEVEN
Gord Dibben MS Excel MVP
On Wed, 2 Jun 2010 07:46:01 -0700, HunterX
>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 !!