From the course: Excel 2016 Essential Training

Unlock this course with a free trial

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

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 Buy for my team

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