Forum Discussion
Admaiora61
Aug 21, 2023Copper Contributor
Isolating Operators in a Cell Reference
Is there a way to write the following uinsg <= in a cell reference? Kindly refer to the folloiwng:
=IF(L2&"<="&D2,E2)
Cell C2 conatins <= but when I reference the cell, it wraps it in quotes which results in #VALUE!
- In general I'd say yes unless you want to change that cell C2 and not go into the formula. Another variant is:
=IF(COUNTIF(L2, C2&D2),E2)
As variant
=IF( SWITCH(C2, "<", L2<D2, "<=", L2<=D2, "=", L2=D2, ">", L2>D2, ">=", L2>=D2 ), E2 )
- Admaiora61Copper ContributorThank you for quick response Sergei.
It would appear easier just to use the operators in the expression in lieu of a cell reference.- mtarlerSilver ContributorIn general I'd say yes unless you want to change that cell C2 and not go into the formula. Another variant is:
=IF(COUNTIF(L2, C2&D2),E2)