Aug 24 2022 10:12 AM
Hello,
For B17 & C17, when I type Akron in B17, according to the formula which is identical to every other city listed that all appear, for some reason it says FALSE. I have tried entering it in different areas in the formula. I have added other cities after it and they work but Akron doesn't. Why? Can anyone help me? Here is a screen shot of my sheet:
Aug 24 2022 10:36 AM - edited Aug 24 2022 10:50 AM
Make sure that there is no space before or after Akron in B17.
See @OliverScheurich's reply
By the way, such a formula is hard to maintain. It would be much better to create a lookup list, with cities in its first column and the corresponding percentages in its second column.
You can then use a short and simple VLOOKUP or XLOOKUP formula. And if you need to add or change something, you only need to do it in the list, instead of updating multiple formulas.
Aug 24 2022 10:42 AM
In the formula there is no percentage for "Warrensville Heights" and no result/answer for TRUE. "Akron" and it's percentage are entered twice but this shouldn't matter.