Aug 21 2023 09:42 AM
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!
Aug 21 2023 10:04 AM
As variant
=IF( SWITCH(C2, "<", L2<D2, "<=", L2<=D2, "=", L2=D2, ">", L2>D2, ">=", L2>=D2 ), E2 )
Aug 21 2023 10:18 AM
Aug 21 2023 10:33 AM
SolutionAug 21 2023 10:55 AM
Aug 22 2023 06:56 AM