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!
Bookmarks