With Analysis Toolpak add-in loaded.

In an adjacent column enter.

=IF(ISEVEN(ROW()),ROUNDDOWN(A1,0),ROUNDUP(A1,0))

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
wrote:

Hello,

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 !!