Default to a backup value if one cell is blank

Hi experts,
I'm having trouble on how to show the value in C2 if there's no value in D2.
Please look at the sample that i attached in here.
F2 should be 15 not 0.

Adding Reputation to you is all i can do for helping me

Something like this maybe:

In F2: =IF(LEN(D2)=0, C2, D2)

Hi khr0n0s,

I think the problem might be that your first "A" has a space in front of it? See the attached for two different methods to get what I think you want.

I want rep.xlsx

Enter in E2 and copy down then you formula in F2 will work

Formula:

Please Login or Register  to view this content.

v	A	B	C	D	E	F
1	Blah Blah 1	Date	Blah Blah 2	Blah Blah 3	Helper (hide column)	Result
2	A	1/1/2017	10		A	15
3		1/2/2017			A
4		1/3/2017			A
5		1/4/2017	5		A
6		1/5/2017			A
7		1/6/2017			A
8		1/8/2017			A
9	B	1/9/2017	15	7	B	-3
10		1/10/2017		1	B
11		1/11/2017		2	B
12		1/12/2017		3	B
13		1/13/2017	2	2	B
14		1/14/2017		5	B
15	C	1/13/2017	10	6	C	4

Originally Posted by AlKey

Enter in E2 and copy down then you formula in F2 will work

Formula:

Please Login or Register  to view this content.

v	A	B	C	D	E	F
1	Blah Blah 1	Date	Blah Blah 2	Blah Blah 3	Helper (hide column)	Result
2	A	1/1/2017	10		A	15
3		1/2/2017			A
4		1/3/2017			A
5		1/4/2017	5		A
6		1/5/2017			A
7		1/6/2017			A
8		1/8/2017			A
9	B	1/9/2017	15	7	B	-3
10		1/10/2017		1	B
11		1/11/2017		2	B
12		1/12/2017		3	B
13		1/13/2017	2	2	B
14		1/14/2017		5	B
15	C	1/13/2017	10	6	C	4

Commended. Thanks :D

In the second method you need to refresh the Pivot Table for it to show the correct answer.