SOLVED

Isolating Operators in a Cell Reference

Copper Contributor

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!

 

5 Replies

@Admaiora61 

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.
best response confirmed by Admaiora61 (Copper Contributor)
Solution
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)
C2 wll not change. You're solution is an excellent alternate; thank you!
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...