Adjust formula with blanks/no blanks

Hi, I'm trying to figure out how to adjust for blank cells when running calculations. In my example, you'll see that for column H, I want to adjust the figures in column G so that, if a country doesn't have a percent (column F), it pulls from the income classification that the country is considered.

For example, I want Andorra - row 6 to show the amount in D6*B22, since it is considered a high-income country.

Thanks!

Please Login or Register  to view this content.

Could use this formula with named table.

Formula:

Please Login or Register  to view this content.

Hi! It's almost there. I don't want it to return the value located in B22-B26 but instead I want it to use that as the multiplier. So right now for Andorra it's returning .84 which is the rate for high-income countries. But I want it to do that times the value in column D. So again for Andorra .84*1691.

Does that make sense?

This is what my formula does.

Excel 365 (Windows) 64 bit

	A	B	C	D	E	F	G	H
1	Countries	Code	1	2	3	4	5	6
2	Afghanistan	AFG	Low income	1234137	0%	1%	13.081,85	13.081,85
3	Albania	ALB	Upper middle income	83227	69%	69%	57.621,55	57.621,55
4	Algeria	DZA	Lower middle income	988272	0%	79%	781.466,18	781.466,18
5	American Samoa	ASM	High income	2327	0%	68%	1.591,50	1.591,50
6	Andorra	AND	High income	1691	0%	0%	-	1.416,99
7	Angola	AGO	Lower middle income	2334213,5	0%	40%	924.605,76	924.605,76
8	Antigua and Barbuda	ATG	High income	2104,5	0%	70%	1.478,49	1.478,49
9	Argentina	ARG	Upper middle income	1988442,5	0%	76%	1.514.927,79	1.514.927,79
10	Armenia	ARM	Upper middle income	109181	29%	29%	31.427,50	31.427,50
11	Aruba	ABW	High income	2112,5	0%	104%	2.186,88	2.186,88
12	Australia	AUS	High income	618596,5	0%	160%	991.080,58	991.080,58
13	Austria	AUT	High income	258173	0%	103%	265.549,36	265.549,36
14	Azerbaijan	AZE	Upper middle income	421042	46%	46%	194.898,61	194.898,61
15	Bahamas, The	BHS	High income	9258	0%	40%	3.679,08	3.679,08
16	Bahrain	BHR	High income	58957	0%	53%	31.013,17	31.013,17
17	Bangladesh	BGD	Lower middle income	8772784,5	36%	36%	3.191.599,33	3.191.599,33
18	Barbados	BRB	High income	6023	75%	75%	4.524,88	4.524,88
19	Belarus	BLR	Upper middle income	277425	97%	97%	268.453,98	268.453,98

Sheet: Sheet2