From the course: Excel 2013 Essential Training

Unlock the full course today

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

Using IF functions and relational operators

Using IF functions and relational operators - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using IF functions and relational operators

One of Excel's most powerful functions is the IF function. It's almost programming-like in nature. It gives us the ability to come up with alternate answers depending upon the content of certain cells or calculations that we're comparing it with. In column G, we want to establish a shipping cost that's going to be 2% of the total cost except in cases when the total cost reaches 1500. We see in cell C4 a description, "No shipping charge for orders over $1500" so to make this clear, I'm going to make column G wider and also use the Zoom slider bar so that we can see this a bit better. Ultimately, column G doesn't have to be this wide. The IF function allows us to test a condition and then come up with two different answers in its basic form; "=if", we simply want to check that entry in F7 to see if it's greater than 1500. Greater than 1500, this does not mean if it's equal to 1500, it means greater than and if the person who's designing this says, well, I want 1500 to be the breakpoint,…

Contents