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)
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)
=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...
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...