Prev: Counting Occurrence of a Value within Cells
Next: difference between two time
From: Gord Dibben on 2 Jun 2010 11:55
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
<HunterX(a)discussions.microsoft.com> 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 !!

First  |  Prev  | 
Pages: 1 2
Prev: Counting Occurrence of a Value within Cells
Next: difference between two time