Forum Discussion

EScotty27's avatar
EScotty27
Copper Contributor
Dec 14, 2022
Solved

Help with formula my coworker made and I can't adjust

I need help fixing a formula that will exclude all answers of a specific value, despite them meeting the current criteria of the formula. For example, in the following formula, I need it to exclude E...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 14, 2022

    EScotty27 

    =IF(OR(COUNTIF(D12,"*"&Flower[Flower]&"*"),AND(E12>=1.75,E12<>4.25)),E12,0)

     

    (I omitted SUM since it doesn't do anything here)

HansVogelaar's avatar
HansVogelaar
MVP
Dec 14, 2022

EScotty27 

=IF(OR(COUNTIF(D12,"*"&Flower[Flower]&"*"),AND(E12>=1.75,E12<>4.25)),E12,0)

 

(I omitted SUM since it doesn't do anything here)

EScotty27's avatar
EScotty27
Copper Contributor
Dec 15, 2022
This worked! Thanks so much!