If a column contains "%"--> how can I use this type for a formula? i.e. if states "%" do formula, otherwise use a number from another column?
I'm struggling. I have a column which contains either %, /nl or 10^9 as a outcome. the linked numbers in another column have to be converted depending on these expressions. How should I use the column properties and which comparison or expression in the formula should I use? Most use a numerical part for this, but I need now the characters. if --> % than calculate number *100, if not do xxx