Dec 14 2022 07:35 AM
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!
Dec 14 2022 12:20 PM
Solution=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)
Dec 15 2022 06:33 AM
Dec 14 2022 12:20 PM
Solution=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)