From the course: Excel: Financial Functions in Depth

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

IF: Building logical comparisons

IF: Building logical comparisons - Microsoft Excel Tutorial

From the course: Excel: Financial Functions in Depth

Start my 1-month free trial Buy for my team

IF: Building logical comparisons

“

- [Instructor] The IF function is technically not a finance function. It sits here under logical functions, but together with the date functions, it is incredibly useful for all sorts of financial calculations. So firstly, let's have a look at the syntax for the IF function. I'll bring up the dialogue box and what we're trying to do here in the first example is to work out whether or not we should go ahead with the deal, and what we are testing is whether the value of the deal is greater than or equal to the cost of the deal. And if that is the case, we want to accept, and if not, we want to reject. And because we have typed text into the formula, we need to use inverted commas, and the beautiful thing about using the dialogue box is that it will automatically do that for us. So there we go. So that is firstly the syntax for the IF function. So let's go ahead now and include the IF statement in a spend schedule down below here, and what we are testing is we want the cost to be spread…

Contents