ModeLoop: Financial Modelling in Excel

Excel IF, AND, OR Functions for Financial Modelling (P2E4)


Listen Later

Master Excel's IF, AND and OR functions and combine them to build models that react to real financial conditions: covenant tests, distribution locks, flags and waterfall logic.

In this episode:

  • IF syntax, examples and nested IFs
  • AND for all-conditions-true tests (covenants, distributions)
  • OR for at-least-one-true flags
  • Combining IF, AND and OR in waterfall and covenant logic

πŸ“– Full blog post: https://modeloop.net/Blog/P2E4-Logical-Functions-Explained-IF-AND-OR
πŸ“Ί Watch the video lecture: https://youtu.be/OXD5i_whMzI
πŸŽ“ Courses: Excel for Financial Modelling | AI in Project Finance Modelling
🌐 modeloop.net

ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.

...more
View all episodesView all episodes
Download on the App Store

ModeLoop: Financial Modelling in ExcelBy Samir Asadov, CFA