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...
I also tried IFS function just now. Miraculously (!) I also works up to 0.
I got so worked up when it evaluated IFS(TRUE;3960;FALSE;0;FALSE;0;FALSE;0;FALSE;0;FALSE;0) to be 0.
I'm speechless right now. What would you recommend?
I got so worked up when it evaluated IFS(TRUE;3960;FALSE;0;FALSE;0;FALSE;0;FALSE;0;FALSE;0) to be 0.
I'm speechless right now. What would you recommend?