4 ms·
>Also making if-else statement in Excel is exhausting. About a year ago Excel added =SWITCH, which is effectively {Logic Test | Output} pairings executed until
by DavidPeiffer 6y ago
>Also making if-else statement in Excel is exhausting.
About a year ago Excel added =SWITCH, which is effectively {Logic Test | Output} pairings executed until one is true. Many if/then/else nestings could be eliminated with it.