I have a table in the form of (and some examples)
3;Blank;Blank (so, should be a number but it’s empty)
Now let’s say i create a new column to calculate Value1/(Value1+Value2) for each line and if it’s over a value have text1, under the value text2 but if it’s empty in both columns it will return a “division by 0” error and i want have text3 instead of that.
Methods that do work:
- use the Rule Action
- Replace text action on the text error
What i am trying that does not work (and i don’t understand why):
IF THEN ELSE, etc, but at the Last ELSE IF THEN I tried with
or even with
Does anybody have any clue why?