From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Using IF functions and relational operators

Using IF functions and relational operators

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using IF functions and relational operators

“

- One of Excel's most powerful functions is called the IF function. It's almost programming-like in nature, and it opens the door to a different way of thinking. The IF function is a conditional kind of function. It allows us to come up with multiple answers, based on a condition. In column G, in this worksheet called IF Function, we're in the workbook 10, IF VLOOKUP COUNTIF, in cell G4, we're going to apply a shipping charge. If the subtotal in column F is over 1,500, we want that shipping charge to be forgotten, in other words, no shipping charge. Otherwise, it's going to be 2%. So we want a formula in G4 that checks the data in F4. If it's greater than 1,500, the shipping charge is zero. Otherwise, it's 2%. In column H, we've got a total that's adding these two columns, even though, for the moment, column G is empty. So we see why we're getting the same number there. Now, column G does not really have to be made wider, but in order to see the function, I'm going to make column G…

Contents