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