DylanGrimm
New Member
- Joined
- Apr 30, 2015
- Messages
- 4
So i have a list of prices and a table that states acceptable price points. For example if i have a price of $1.32, the table says that is an unacceptable price and you must use the lower acceptable price which would be $1.29. Below is the table.
<colgroup><col style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98"> <col style="width: 48pt;" span="16" width="64"> <tbody>
</tbody>
What im trying to do is form this table just as a reference, so i can have it in a workesheet, and have a formula us it as a reference. That way when i have a list of prices i can just fill that formula down and it will spit out all the acceptable price points.
What would that fomula look like and how should this table look?
| Under $1.00 | 0.25 | 0.33 | 0.39 | 0.44 | 0.45 | 0.49 | 0.55 | 0.59 | 0.65 | 0.69 | 0.75 | 0.79 | 0.88 | 0.89 | 0.99 | |
| $1.00 - $1.99 | 1.00 | 1.09 | 1.19 | 1.29 | 1.39 | 1.49 | 1.59 | 1.69 | 1.79 | 1.89 | 1.99 | Note1: Keep 1.09 but use competitive prices to move in either direction when appropriate | ||||
| $2.00 - $2.99 | 2.19 | 2.29 | 2.39 | 2.49 | 2.59 | 2.69 | 2.79 | 2.89 | 2.99 | |||||||
| $3.00 - $3.99 | 3.19 | 3.29 | 3.39 | 3.49 | 3.59 | 3.69 | 3.79 | 3.99 | ||||||||
| $4.00 - $4.99 | 4.19 | 4.29 | 4.39 | 4.49 | 4.59 | 4.69 | 4.79 | 4.99 | ||||||||
| $5.00 - $5.99 | 5.29 | 5.49 | 5.59 | 5.79 | 5.99 | |||||||||||
| $6.00 - $6.99 | 6.29 | 6.49 | 6.59 | 6.79 | 6.99 | |||||||||||
| $7.00 - $7.99 | 7.29 | 7.49 | 7.59 | 7.79 | 7.99 | |||||||||||
| $8.00 - $8.99 | 8.29 | 8.49 | 8.59 | 8.79 | 8.99 | |||||||||||
| $9.00 - $9.99 | 9.29 | 9.49 | 9.59 | 9.79 | 9.99 | |||||||||||
| $10.00 - $14.99 | xx.49 | xx.99 | ||||||||||||||
| $15.99 - $19.99 | min = 15.99 | xx.49 | xx.99 | Note2: no $15.49 | ||||||||||||
| $20.00 - $29.99 | min = 21.99 | xx.49 | xx.99 | Note3: no $20.49 **we need to verify 20.99 as there is a cluster of items at that price** | ||||||||||||
| $30.00 + | min = 31.99 | xx.49 | xx.99 | Note4: no $30.49 or $30.99 |
<colgroup><col style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98"> <col style="width: 48pt;" span="16" width="64"> <tbody>
</tbody>
What im trying to do is form this table just as a reference, so i can have it in a workesheet, and have a formula us it as a reference. That way when i have a list of prices i can just fill that formula down and it will spit out all the acceptable price points.
What would that fomula look like and how should this table look?
