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