PrecisionCalc
inspector
text
Do Anything with Text in Formulas
itCONCATULA
Evaluates a concatenated formula, or any other alltext formula in which the operator is text.
Evaluates any of the following arithmetic and comparison operators: +, , *, ^, /, =, <>, <=, >=.
Syntax
itCONCATULA(text_formula)
text_formula  Required. The text formula
to evaluate. Must be in the form <number><operator><number>. Can accept a leading equal sign ("="), but does not require one. Any other leading operator will result in an error. Accepts the following operators: +, , *, ^, /, =, <>, <=, >=. In addition, ><, =<, and => are accepted and treated as <>, <=, and >= respectively. Does not accept parentheses. 
Examples
Formula  Description  Result  
=itCONCATULA("1+2")  Evaluate the formula 1+2 and return the result.  3  
=itCONCATULA(A1&B1&C1)

Evaluate the formula created by concatenating "1", "+", and "2", and return the result.  3  
=itCONCATULA("=1.23+200.1")  Evaluate the formula =1.23+200 and return the result.  201.33  
=itCONCATULA("1>=2")  Evaluate the formula 1>=2 and return the result.  FALSE  
=itCONCATULA("3^(1/5)")  Evaluate the formula 3^(1/5) (the fifth root of 3) and return the result.  #VALUE! itCONCATULA cannot accept parentheses. See next example for how to evaluate an nth root using the power ("^") operator. 

=itCONCATULA("3^"&itCONCATULA("1/5"))  Evaluate the formula 3^(1/5) (the fifth root of 3) and return the result.  1.24573093961552 