tiffsauder
New Member
- Joined
- Oct 18, 2012
- Messages
- 3
Hello,
I have a document with several sheets on it that contain tables of pricing for individual products. (When I say tables I do not mean tables that were made with the tables feature. I simply created them by formatting the cells within the table. There is no sorting options or anything included. Without the formatting of fill colors, and font features they would simply be cells with formulas.)
<colgroup><col style="text-align: center; "><col span="8" style="text-align: center; "></colgroup><tbody>
</tbody>
I copy and pasted one of the tables above.
I am new to the forum so I am not sure how to display things in the best way. Tips for that would be wonderful!
The quantities are the 250, 500, 1000, 2500 listed under the All Purpose Scraper which is the item, the item number is listed under the "Qty Breaks". The item number will need to be my lookup value. The prices below each quantity apply to the customer based on how many pieces they purchase. Under the quantity is letter "R" this is a code that is equal to a percentage. Next to it is the "Net" price. Under each of those is the price that applies. All the prices are figured based on formulas. The two cells above the "R" and "Net" are merged and contain the quantity.
What I need to do is return return the above values in a table like this...
<tbody>
</tbody>
I need a formula that will return the values in red...
Can anyone help?
I have a document with several sheets on it that contain tables of pricing for individual products. (When I say tables I do not mean tables that were made with the tables feature. I simply created them by formatting the cells within the table. There is no sorting options or anything included. Without the formatting of fill colors, and font features they would simply be cells with formulas.)
20% | All Purpose Scraper | |||||||
Qty Breaks | 250 | 500 | 1000 | 2500 | ||||
R | Net | R | Net | R | Net | R | Net | |
11000 | $0.80 | $0.48 | $0.76 | $0.46 | $0.71 | $0.43 | $0.67 | $0.40 |
<colgroup><col style="text-align: center; "><col span="8" style="text-align: center; "></colgroup><tbody>
</tbody>
I copy and pasted one of the tables above.
I am new to the forum so I am not sure how to display things in the best way. Tips for that would be wonderful!
The quantities are the 250, 500, 1000, 2500 listed under the All Purpose Scraper which is the item, the item number is listed under the "Qty Breaks". The item number will need to be my lookup value. The prices below each quantity apply to the customer based on how many pieces they purchase. Under the quantity is letter "R" this is a code that is equal to a percentage. Next to it is the "Net" price. Under each of those is the price that applies. All the prices are figured based on formulas. The two cells above the "R" and "Net" are merged and contain the quantity.
What I need to do is return return the above values in a table like this...
Item Number | Quantity 1 | Coded Price | Net Price |
11000 | 250 | $.80 | $.48 |
<tbody>
</tbody>
I need a formula that will return the values in red...
Can anyone help?