I uploaded my Excel document and it has numbers (as text; I'm not doing sums, etc.). Some of the cells have 'Not Available'. I can't figure out how to say "If the population count is 'not available' then put 'not available' in the cell. Otherwise input whatever is in the population count cell in the Excel doc.
Here's what I tried. It did not work though (error during data load script)
If ("PopulationCount" = 'Not Available', 'Not Available', "PopulationCount")