Forum Discussion
SWITCH function
I'm using Switch function for my worksheet and at some points even simple evaluations bug into zero. For example : =SWITCH(Baz_Vade;180;R18*$U$8;150;[@[150 gün]]$U$7;120;[@[120 gün]]$U$6;90;[@[90...
Formula with circular reference is always (if only you didn't enable iterative calculations in settings) returns zero, it doesn't matter what is inside the formula.