Important announcement

Dear visitor,

Please note that this OpenCourseWare platform will be replaced at the end of 2026 by a new platform (under the same url ocw.tudelft.nl).

Courses and their contents that are currently available the platform will partly be migrated. URL’s for this content will change and content might be unavailable for some time. In addition, some courses will not be available anymore.

If you are linking to specific courses on this platform (for instance for your students), please take timely measures to avoid problems with access. Possible actions are:

  • Download the materials to your local platform (laptop, server)
  • For educators only (including TU Delft lecturers): Contact us at ocw@tudelft.nl and inform us what course you are using in what context (institute, program, period of use, number of students). We will research (in collaboration with the authors of the course) and decide if we will migrate the course, and if yes, can supply you with a new url.

Thank you.

Home Courses Data Analysis: Take it to the MAX Course materials Lectures 1.5 Conditionals

1.5 Conditionals

Course subject(s) 1. Intro and Conditionals

Learning how to use conditional statements, namely the IF and SUMIF functions. We will leverage this knowledge to find the health of our stock portfolio, which shares to sell, how much money we will make. Also some more tips on how to use spreadsheet space effectively!

Please note that assume we have inherited the shares from a rich uncle, meaning we got them for free. As a result the profit is simply equal to the money we make now, there is no initial investment that we need to subtract from it.

Creative Commons License
Data Analysis: Take it to the Max by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-take-it-to-the-max/.
Back to top
[sg_popup id=6]