Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Spreadsheet Basics

Well done!

You have completed Spreadsheet Basics!

Sign up for Treehouse Back to Library

The CHOOSE Function

2:37 with Michael Watson

The CHOOSE function allows you to enter an index number and return a value based on that index. It's used regularly for applying different scenarios to business forecasting.

Example Files

  • you can continue to use the spreadsheet from the last video, or
  • open a copy of this spreadsheet to catch up to this video

Reference

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    applying different scenarios to our forecasting tools. 0:00
    In this example we're looking at a very simple business, 0:02
    we have sales, costs, then profit or loss. 0:05
    We can use the CHOOSE function to determine how different amounts of sales 0:11
    will impact our profit or loss. 0:14
    So here, we've entered CHOOSE, then we have the index number, 0:16
    B13, in this case B13, then all the different indexes. 0:22
    So, let's retype this formula so we can learn it together. 0:27

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up