People and Helpers
I am trying to alter the type of operator used in one formula based on the result of an argument in a separate cell generally as follows:
If Cell 1 equals something then use the ">" operator, otherwise use the "=" operator.
I appreciate this sounds really simple and I'm having a major brain fade as I cannot figure out how to relate the two arguments as follows:
[If(Value 1 "Operator" Value2, then do something, otherwise do something else) ]
where the operator is pre-defined in another formula.
Many thanks in advance as I have had nothing but briliant results from this forum!