MS Excel Data Table Part 2
HOME We will do one more Data Table, just so that you get the hang of things. This time, we will use a more simple formula than PMT, and we will use Rows instead of Columns. This is the scenario: You have 250 items that you want to sell on Ebay. Your unique selling point in this – All items are only $5 each. Except, you feel $5 may be a bit expensive for the goods you are selling, what you want to know is how much profit you will make if you reduce your prices to $4.50, how much if you reduce to $4.00, and how much for a reduction to $3.50. Assume that everything gets sold. To start creating your table, construct a spreadsheet like the one below. Make sure that you start on a new sheet. In cell B1 is the number of items we want to sell (250). Cell B2 has the original price ($5.00), and the Reductions row has our new values. Cell B3 has a 0 because there is no reduction for $5. Row 4 is where our Profits will ...