Lecture 04
IF Formula in MS Excel
IF formula can be a headache, as anybody who has spent a significant amount of time creating different financial models is aware. To make formulae simpler to audit and comprehend for other users, IF can be used with the AND or OR function. You can see how we combined the several functions to get a more complex formula in the example below. Please refer to our free article on how to use IF with AND / OR for a thorough explanation of how to carry out this function in Excel.
.png)