SOLVED

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

Copper Contributor

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 E12 if it returns with the value of 4.25 but I'm not sure how to fix it:

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

 

I know that its including the 4.25 because of the limits applied in the OR function but I'm not sure how to make it exclude just that one specific value without returning as an error or invalid formula. I am very inexperienced with Excel but can understand the logic patterns. My previous coworker wrote this and then left so all updates have now fallen on my non-IT shoulders. Appreciate any and all help!

2 Replies
best response confirmed by EScotty27 (Copper Contributor)
Solution

@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)

This worked! Thanks so much!
1 best response

Accepted Solutions
best response confirmed by EScotty27 (Copper Contributor)
Solution

@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)

View solution in original post