Trying to add multiple IF if first cell is blank use another cell, but if that cell is blank use another cell.

[floW_5]

Sample.xlsx
	A	B	C	D	E	F	G	H	I
1		Sample	Title	Column1	Column2	Column3	Column4	Column5
2			Red	5	5	5	4	-0.20
3			Blue	7	6	4		-0.14
4			Yellow	3			5
5			Green	9	3	4		-0.67
6			Orange	11			2
7
8
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IFERROR(IF(G2,(G2-F2)/F2,(E2-D2)/D2),"")

So I am able to figure out the first condition with the IF function, and I have been playing around with AND/OR for the second condition but have not been able to add onto the current formula to achieve the results I'm looking for.

Using table above (table name is called "Sample")
My conditions are:
(G2-F2)/F2 BUT IF G2 is blank use (E2-D2)/D2) (which I have achieved with the current formula in the table)
BUT IF E2 AND F2 is blank use (G2-D2)/D2 instead.

How could I write up a formula to meet these conditions?

 

[Elle_mostlysunny]

Sample.xlsx
	A	B	C	D	E	F	G	H	I
1		Sample	Title	Column1	Column2	Column3	Column4	Column5
2			Red	5	5	5	4	-0.20
3			Blue	7	6	4		-0.14
4			Yellow	3			5
5			Green	9	3	4		-0.67
6			Orange	11			2
7
8
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IFERROR(IF(G2,(G2-F2)/F2,(E2-D2)/D2),"")

So I am able to figure out the first condition with the IF function, and I have been playing around with AND/OR for the second condition but have not been able to add onto the current formula to achieve the results I'm looking for.

Using table above (table name is called "Sample")
My conditions are:
(G2-F2)/F2 BUT IF G2 is blank use (E2-D2)/D2) (which I have achieved with the current formula in the table)
BUT IF E2 AND F2 is blank use (G2-D2)/D2 instead.

How could I write up a formula to meet these conditions?

Sample.xlsx
	A	B	C	D	E	F	G	H	I
1		Sample	Title	Column1	Column2	Column3	Column4	Column5
2			Red	5	5	5	4	-0.20
3			Blue	7	6	4		-0.14
4			Yellow	3			5
5			Green	9	3	4		-0.67
6			Orange	11			2
7
8
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IFERROR(IF(G2,(G2-F2)/F2,(E2-D2)/D2),"")

So I am able to figure out the first condition with the IF function, and I have been playing around with AND/OR for the second condition but have not been able to add onto the current formula to achieve the results I'm looking for.

Using table above (table name is called "Sample")
My conditions are:
(G2-F2)/F2 BUT IF G2 is blank use (E2-D2)/D2) (which I have achieved with the current formula in the table)
BUT IF E2 AND F2 is blank use (G2-D2)/D2 instead.

How could I write up a formula to meet these conditions?

Hi, mine might be a long cut but i understand it this way

IF(AND(E2="",F2=""),(G2-D2)/D2,IF(G2="",(E2-D2)/D2,(G2-F2)/F2))

 

[Elle_mostlysunny]

Hi, mine might be a long cut but i understand it this way

IF(AND(E2="",F2=""),(G2-D2)/D2,IF(G2="",(E2-D2)/D2,(G2-F2)/F2))

Also you can use OR instead of AND just in case only one of E2 or F2 has a value, using AND means E2 and F2 should be both blank

 

[SunnyAlv]

like this ??

=IFERROR(
IF(G2<>"",(G2-F2)/F2,
IF(G2="",(E2-D2)/D2,
IF(AND(E2="",F2=""),(G2-D2)/D2))),"")

 

[floW_5]

like this ??

=IFERROR(
IF(G2<>"",(G2-F2)/F2,
IF(G2="",(E2-D2)/D2,
IF(AND(E2="",F2=""),(G2-D2)/D2))),"")

This still leaves H4 and H6 blank unfortunately. I appreciate the help though. Thank you.

 

[floW_5]

Hi, mine might be a long cut but i understand it this way

IF(AND(E2="",F2=""),(G2-D2)/D2,IF(G2="",(E2-D2)/D2,(G2-F2)/F2))

This works good. Thank you mate. Appreciate the effort!!!

 

[floW_5]

Also you can use OR instead of AND just in case only one of E2 or F2 has a value, using AND means E2 and F2 should be both blank

Will keep this in mind. Thank you