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

  • 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.