Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Excel 2013 tutorial, the trainer shows how to use logical function specifically the "if statement" function in Excel 2013.

Get the full course on Excel 2013 course here: https://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2013-training-tutorials/

Watch the Excel 2013 playlist: https://www.youtube.comhttp://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Welcome back to our course on Excel 2013. We’ve been looking at a case study, the production of an invoice for a plumbing supplies company as a way of looking at the functions that are available in Excel 2013 in a bit more detail. In this section, we’re going to look at what are called Logical Functions. This is functions which will cause us to do one thing in one set of circumstances and different things in different circumstances.

Now in order to look at Logical Functions or an example of the Logical Function, we’re going to look at the table that we placed in the invoice. This was earlier on in the course and we’ve currently got half a dozen items in that table, which are part of this order. Now the items that we’ve got there we’re actually going to delete. So I want to clear all of these cells.

I’m just going to select them and the easiest way to clear them is just to click on the Delete key. Now we are instead going to populate the order with items from our latest catalogue. Now the latest catalogue is the second worksheet in this workbook. So if you click on Catalogue, you can see we have product codes, descriptions for each of the products, a quantity or size for each, a list price, and then certain clients can get a discount and the percentage discount is marked here in Column E, and then for customers that get the discount the net price to them is in Column F. Now the feature that we’re going to put into this part of the invoice is that some customers will pay the list price without the discount and some will pay the net price. Now if I click back on to the Customers Worksheet this column, E, in the Customer Worksheet says whether a customer gets the discount or not. So customers 2971 and 2973, Frequent Showers and West Beach Bathrooms get the discount. They have Yes. The other two don’t get the discount. There isn’t any particular reason why two of them do and two of them don’t other than to demonstrate what we’re doing in this section.

So let’s go back to the Catalogue and look again. We’ve got a product code, description, and we’ve got prices. Now let’s go back to the invoice and see how we’re going to put all this together. Now there’s one thing about this table that I’m not entirely happy about and that is that I really ought to have a unit cost there. I’ve got a cost figure. I’ve got an order quantity. I really would like to see a unit cost. So what I’m going to do is to put the selection here in the order quantity column in the table, go to the Insert on the Home tab, and select Insert Table Columns to the left.

And on that column the field that I’m going to select, what I’m going to call it is Unit Cost. So when I come to calculate the cost for a particular item in the order it will be order quantity multiplied by unit cost.

Now I should point out that when it comes to adjusting the widths of these columns, they are interconnected with the widths of the columns in the sheet overall. So there’s a certain amount of adjustment needed here to balance up the widths of these columns. But that’s not really the primary purpose of what we’re doing in this section. So if you want to tidy that up, you should know how to do that now. I’ll leave that to you. I’m just going to put that extra column in.

So let’s just take another quick look at the Catalogue. The Catalogue, first column is the product code, second column is the description, third column is the quantity size that goes with the description. So let’s go back here to the invoice. Let’s look. Product code will go in there. That’s what we select. And then we want to AutoFill in what the description is. Now we know that in order to do that we need a Lookup Function, we need a VLOOKUP.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.