Forum Discussion
Nestet if else
Hello to everybody, I don't get it. I don't know why. Maybe to long working days. It is a easy problem but I am lost. I would like to check the results for the column "Bedarfsmenge" to column "B...
Hi Anonymous ,
As I look at your picture, the data type has not been selected in the columns.
First I would fix that.
Next if the value = "null" use that in your formula. If the value = 0 then use that in your formula.
Finally it is easier to write a SWITCH(TRUE()).
So it might look like this:
SWITCH(TRUE(),
Column1<>0,
Column2<>0,
Column3<>0
)
This formula uses whichever value is true that it comes to first. So, if Column1 <> 0 is true, it will use that value and if not it will continue checking subsequent values.
Hope this helps.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel