Do Anything with Text in Formulas
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: +, -, *, ^, /, =, <>, <=, >=.
|text_formula||Required. The text formula
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.
|=itCONCATULA("1+2")||Evaluate the formula 1+2 and return the result.||3|
|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|
PrecisionCalc Home Page