#16 Control Flow

date
May 20, 2023
slug
16-flow
status
Published
tags
summary
Learning about control flow
time
0h-15m
type
Post
Busy today with lots of other things going on. Only managed to make some progress. Learned about control flow in excel using ifs, switch.
  • IFS(case1, true_case1, [case2, true_case2, ...]) can be used instead of going nested ifs.
    • If no condition is met then N/A is returned
  • SWITCH() works same except it matches the text values instead of logical conditions
  • Which to use ?
    • IF() when based on single condition check
    • IFS() extends to multiple conditions
    • SWITCH() transform categorical values
 

© ibrar 2023