Hi Folks -
I need to write a rather large IF statement. I"m 75% of the way there however I need to add another exception. The caveat is, the additional exception consists of 26 additional exceptions.
Allow me to explain.
If cell in Column T > 0, I then determine what country I am dealing with by checking the prefix of the cell in Column A. Based on that, I divide the value in Column T by the country specific number to determine the the FTE figure - this part is working great.
The caveat is, if the cell in Column T equals 0, I need to then go to the cell in Column AG to determine the Host Country, then based on what is returned, divide the value in Column AL by the number which represents that Host Country.
As you can see, there are 27 countries, so each part of that If (if Column T = 0) I need to repeat this exception 26 times to capture all potential countries.
Is there an easier way to do this?
Thank you!
Bookmarks