Hi

Try
=IF(MOD(ROW(),2)<0,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

Depending upon whether the first row you are trying to Roundup is Odd (use
formula as is) or if even the change < to =

Copy down as required
--

Regards
Roger Govier

"HunterX" wrote in message
...
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 !!

__________ Information from ESET Smart Security, version of virus
signature database 5166 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5166 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com