Create Your Shopping Bill in Excel for Shipping Effortlessly

Shopping bill in excel for Shipping

what's up Willam bar here with dark fix.net uh let's say that we are uh going to be doing a store and so uh an internet based store and so what we need to do let's just say that we've got products so these right here are our product we're going to insert a new row and this is product one oops one this is product two t on it product two and this is product three okay now we got one 2 3 4 five and six okay so now what we need is we need a shipping cost excuse me so let's go ahead and add in a top row and this is our shipping and handling and excuse me again the shipping cost is going to be $4 $445 and so what we need to do is that we need to calculate our product cost and our shipping cost and so how we do our product cost and our shipping cost is that we come over here and we do an equal we click on our shipping cost which is B1 we come up here we need to make it so that it's Dynamic what dynamic means is dynamic means that you can use it over and over again and the value will change each time that you use it excuse me and so what we need to do is that we need to add a money sign and a money sign so that's a money sign before and after the column letter and so now we add a plus and then we come down here and we click on the one that we want to do our calculating with which is our B column and so that's going to be B3 and so now what we do is that we click on enter and it gave us the false I'm sorry I put it equal it's supposed to be a plus so it's plus not equal now let's hit enter okay so $869 plus $445 = $13.14 and so we need to drag this across to pick up all of our rows so we click here take our cursor to where it turns into the little black cross and count 2 three four five and six and so that right there would give us the value of our each product and the shipping cost so if you ship out all these items together then you got it made excuse me and so that is how you add in a shipping cost and its value all right Wayne bar here with do b.net y'all have a rocking week byebye