View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Dyer Matthew Dyer is offline
external usenet poster
 
Posts: 178
Default 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?