Cellwise · Advanced logic
Many outcomes with IFS and SWITCH
Tidier alternatives to nested IFs.
You can handle many outcomes in a formula others can read.
This lesson has 3 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.
Start the lesson, free