If BLANK input data from cell Above

[Ravey]

Hello,

I'm trying to create a formula where {IF has content stay the same, IF is Blank then add content of cell above}.

Here's what I'm trying to do:
In Cell D2 I want to write a formula that will READ Cell A2 and Copy it if it has content. The same formula is used in D3 which will read A3 and if there is TEXT then copy it, if there is not TEXT then use the TEXT from above cell D2.

	A	B	C	D (I want this in Column D)	E
1	Channel	Sessions		Channel	Sessions
2	Affiliates	7		Affiliates	7
3		5		Affiliates	5
4	Paid	8		Paid	8
5		9		Paid	9
6	Organic	10		Organic	10
7		5		Organic	5
8		5		Organic	5

<tbody>
</tbody>

 

[Scott Huish]

In D2:

=IF(A2="",D1,A2)

Copy down.

 

[Steve_R]

Assumes A2 always has a value.

Excel 2010

	A	B	C	D
1	Channel	Sessions		Channel
2	Affiliates	7		Affiliates
3		5		Affiliates
4	Paid	8		Paid
5		9		Paid
6	Organic	10		Organic
7		5		Organic
8		5		Organic

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =IF(ISBLANK(A2),D1,A2) <tbody> </tbody>

<tbody>
</tbody>

 

[Ravey]

That worked thank you!

In D2:

=IF(A2="",D1,A2)

Copy down.