Forum Discussion
Multiple Criteria IFS function AGAIN so sorry
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...
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.