Calling operators in formulas
Posting here since this group is much more active than the regular excel board.
Is it possible to call the 'operator' value of a cell as opposed to the 'text' value?
Example- A1 contains ''
A2 contains 2
A3 contains 1
I want to test =A2A3
Using the formula =A2&A1&A3 gives '21 instead of True. Is there some other way to do this?
|