price for profit
Also note that for Rows 3 - 6 , each cell is using the increase of 10% from the cell below it in the column to return the correct price. Click on cell G3 , and you can see the basic formula is the same as in cell B3 .
Working with higher quantity orders works the same way. In fact, once you get the hang of how these spreadsheet formulas work, creating multiple versions for pricing scenarios is easy. We’ll touch on that later. For the Example Pricing 1 worksheet, all of the prices are basically either 10% higher or 10% lower than a relational cell, depending on what Row you are using.
But will that make a good Price List ? Maybe. Maybe not.
Example Pricing 2 Worksheet That’s why I created the Example Pricing 2 worksheet. At the bottom of the spreadsheet click over to this tab and check it out.
For this one, there have been some formula changes that make a big difference in how the Pricing Range plays out.
At first glance, this Price List looks completely different than Example Pricing 1 . But, it shares a lot of the same information. Look at Row 7 for example. This is our Keystone Cell row.
All of the numbers in the cells are exactly the same as in Example Pricing 1 . What’s changed are the formulas that operate the cells
35
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs