ABCDEFGHIJKLMN
1
result I want
Result for copying A2,A3,A4 down
Result i want
2
6.00106.0010=if('2019'!D3'=0,"",'2019'!D3)=if('2019'!G3'=0,"",'2019'!D3)7.000016.0010
3
1.00001.1153=if('2019'!G3'=0,"",'2019'!G3)=if('2019'!D3'=0,"",'2019'!G3)1.11521.1153
4
1.1100
5
3.20007.0000=if('2019'!D6'=0,"",'2019'!D6)=if('2019'!D4'=0,"",'2019'!D4)2.110027.0000
6
1.11031.1152=if('2019'!D6'=0,"",'2019'!G6)=if('2019'!G4'=0,"",'2019'!G4)1.11021.1152
7
1.1103
8
0.00011.1000=if('2019'!D9'=0,"",'2019'!D9)=if('2019'!D5'=0,"",'2019'!D5)6.000531.1000
9
0.00011.1151=if('2019'!D9'=0,"",'2019'!G9)=if('2019'!G5'=0,"",'2019'!G5)1.11031.1151
10
11
6.00223.2000
=if('2019'!D12'=0,"",'2019'!D12)
=if('2019'!D6'=0,"",'2019'!D6)43.2000
12
0.00011.1103
=if('2019'!D12'=0,"",'2019'!G12)
=if('2019'!G6'=0,"",'2019'!G6)1.1103
13
14
52.1100
15
Another Failed Experiment
1.1102
16
1.2200
17
1.1153
18
19
1.2200
20
1.1153
21
22
1.2200
23
1.1153
24
25
6.0005
26
1.1103
27
28
6.0005
29
1.1103
30
31
6.0014
32
1.1102
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48