Forum Discussion

johnsbox's avatar
johnsbox
Copper Contributor
Aug 24, 2022

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 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:

 

Formulas and Functions

2 Replies

Sort By
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 24, 2022

    johnsbox 

    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.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 24, 2022

    johnsbox 

    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.

Resources