Greetings all

I'm trying to get excel to calculate a formula for every other row is this
possible.

Example:
Column A1-A9 has 1 thru 9 in it.
Column C1 has the formula A1+3 and I would like that formula to be in every
other row of C. So C1 would be A1+3 ,C2 would be blank, C3 would be A2+3,
C4 would be blank, C5 would be A3+3 and so on.

Is this possible?
tia sal2

Hi

Try
=IF(MOD(ROW(),2)=1,A1+3,"")
--
Regards

Roger Govier


"(E-Mail Removed)" <(E-Mail Removed)> wrote in message
news:Xns9890481A7165tenotempcom@127.0.0.1...
> Greetings all
>
> I'm trying to get excel to calculate a formula for every other row is
> this
> possible.
>
> Example:
> Column A1-A9 has 1 thru 9 in it.
> Column C1 has the formula A1+3 and I would like that formula to be in
> every
> other row of C. So C1 would be A1+3 ,C2 would be blank, C3 would be
> A2+3,
> C4 would be blank, C5 would be A3+3 and so on.
>
> Is this possible?
> tia sal2

Sub altrowformula()
For i = 2 To 12 Step 2
Cells(i, "H").Formula = "=a" & i / 2 & "+3"
Next i
End Sub
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"(E-Mail Removed)" <(E-Mail Removed)> wrote in message
news:Xns9890481A7165tenotempcom@127.0.0.1...
> Greetings all
>
> I'm trying to get excel to calculate a formula for every other row is this
> possible.
>
> Example:
> Column A1-A9 has 1 thru 9 in it.
> Column C1 has the formula A1+3 and I would like that formula to be in
> every
> other row of C. So C1 would be A1+3 ,C2 would be blank, C3 would be A2+3,
> C4 would be blank, C5 would be A3+3 and so on.
>
> Is this possible?
> tia sal2

Enter this formula in C1:
=INDEX(A:A,ROWS($1:2)/2)+3

And enter this formula in C3:
=INDEX(A:A,ROWS($1:4)/2)+3

NOW ... Select C1 to *C4*,
Click on the fill handle of the *selected 4 cells*,
And drag down to copy as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"(E-Mail Removed)" <(E-Mail Removed)> wrote in message
news:Xns9890481A7165tenotempcom@127.0.0.1...
> Greetings all
>
> I'm trying to get excel to calculate a formula for every other row is this
> possible.
>
> Example:
> Column A1-A9 has 1 thru 9 in it.
> Column C1 has the formula A1+3 and I would like that formula to be in
> every
> other row of C. So C1 would be A1+3 ,C2 would be blank, C3 would be A2+3,
> C4 would be blank, C5 would be A3+3 and so on.
>
> Is this possible?
> tia sal2