Formula needed

[pooja29]

Need a formula wherein the value which is besides the date is reflected in each cell. In Cell C i have used IF formula. But that formala can't b copy pasted. What i want is highlighted in blue.

 

[etaf]

try in C2 & copy down

Book1
	A	B	C
1
2	3/1/18	100
3		12	100
4		14	100
5		16	100
6	3/2/19	101
7		12	101
8		14	101
9		16	101
10		12	101
11		14	101
12		16	101
13	4/3/20	102
14		12	102
15		14	102
16		16	102
Sheet1

Cell Formulas
Range	Formula
C2:C16	C2	=IF(A2<>"","",IF(AND(A1="",A2=""),C1,B1))

 

[pooja29]

Thanks a lot it works. One more query. If there is any text Cell A. Then how this formula will work??

 

[pooja29]

Thanks a lot it works. One more query. If there is any text Cell A. Then how this formula will work??

 

[etaf]

it wont as it is , since its using Blank cells as one of the keys

But TRY
=IF((ISNUMBER(A2)),"",IF((AND(OR(NOT(ISNUMBER(A1)),A1=""),OR(NOT(ISNUMBER(A2)),A2=""))),C1,B1))

 

[etaf]

Book1
	A	B	C
1
2	3/1/18	100
3		12	100
4	Taxes	14	100
5	Taxes	16	100
6	3/2/19	101
7		12	101
8		14	101
9	Part Payment	16	101
10	Taxes	12	101
11		14	101
12		16	101
13	4/3/20	102
14		12	102
15	VAT	14	102
16		16	102
Sheet1

Cell Formulas
Range	Formula
C2:C16	C2	=IF((ISNUMBER(A2)),"",IF((AND(OR(NOT(ISNUMBER(A1)),A1=""),OR(NOT(ISNUMBER(A2)),A2=""))),C1,B1))

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this do what you want?

20 05 03.xlsm
	A	B	C
1	31/03/2020	100
2		200	100
3	text	300	100
4	text	675	100
5	text	700	100
6	1/03/2020	101
7	text	20000	101
8	text	20000	101
Repeat

Cell Formulas
Range	Formula
C1:C8	C1	=IF(ISNUMBER(A1),"",LOOKUP(9^9,A$1:A1,B$1:B1))

.. or this?

20 05 03.xlsm
	A	B	C
1	31/03/2020	100
2		200	100
3	text	300	100
4	text	675	100
5	text	700	100
6	1/03/2020	101
7	text	20000	101
8	text	20000	101
Repeat

Cell Formulas
Range	Formula
C2:C8	C2	=IF(ISNUMBER(A2),"",IF(C1="",B1,C1))