What if scenario
Hi, I'm trying to find a way to allow a change to an operator within an If
statement. This is what I have at present:
=IF(AND(C2=G$3,D2<J$3),(D2+(D2*L$3)),L$4)
This allows me to change the values in the referenced cells, but what I'd
like to do is be allowed to include a reference to the cell containing the
operator < within D2<J$3, to either , =, =, etc. Is this possible?
Can anyone help please.
Thanks.
|