PrecisionCalc
inspector
text
Do Anything with Text in Formulas
itCONCATULA
Evaluates a concatenated formula, or any other all-text 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 |