|
Operator |
Description |
|
[label:] ( ) |
Use parenthesis to group expressions, e.g. to make ‘(2+3)*4’ equal 20. Also, by supplying a label, the expression can be used more than once in a statement without having to copy it textually. A complex expression that you want to use several times is easier to only have to adjust in one place; -or if, in spite of the added Boolean operators, you have to use the same expression in two different branches of an ‘if-then-else’ expression. The label name can contain the letters A-Z, underscore (‘_’) and 0-9. The first letter of the label can only be A-Z or underscore. E.g: ‘if AccumAvg:(avg(d-1,d1:0,m1)) <> 0 then sum(d-1,0,m1) % AccumAvg else 100’ |
|
if [A] then [B] else [C] |
Evaluates to B if A is nonzero, or to C if A is zero. |
Comments
I have a question about: how to bulid the formula if the result of calculation is error and I would like to change it for zero, I mean:
If formula = error then 0 else [formula]
Hi Beata,
Assume you have a calculation like this:
This will result in a "Math error" when the latter part is zero.
To prevent the "Math error", you can change the syntax to this:
BR / Ole
Thank you. It helped ;)
Please sign in to leave a comment.