Forum Discussion
Solved
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...
- 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 )- Thank you for quick response Sergei.
It would appear easier just to use the operators in the expression in lieu of a cell reference.- 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)- Hey mtarler;
The final expression is as follows:
=IF(K2="","",IF(COUNTIF(K2,$B2&$C2),$D2,IF(COUNTIFS(K2,$E2&$F2,K2,$G2&$H2),$I2,$J2)))
It worked perfectly. Thanks a million...
