| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
ugh, sorry for the table wrap,
here's another (better?) paste of the sample table assumed in A4:H7 (labels in B4:H4): List Discount NET List Discount NET BEST BID 1/2" Pipe 1 0.02 0.98 1.05 0.05 0.7 0.7 3/4" Pipe 1.25 0.02 1.23 1.25 0.05 1.2 1.2 1" Pipe 2.1 0.02 2.08 2.17 0.05 2.15 2.08 NET prices are in cols D and G, "Best Bid" is in rightmost col, col H -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I a formula that outputs the number of occurances of a specific t. | Excel Discussion (Misc queries) | |||
| find formula that will look up a value in a specific column and . | New Users to Excel | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
| How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Threaded Mode
