Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the correct value from a pricing grid
Hi Group,
I am not sure if I am doing this right - would appreciate some expert help as I completely stuck. A solver routine returns no of units to produce. (Col B) I have a pricing grid that must be applied to calculate total costs of units produced. (Col D) How do I 'pick up the costs' from my pricing grid to produce Total costs (and influence Solver when it is run again). For example, 275 units are required to be built for Part1, which equals £495. (275 x £1.80) Here is a sample of the tables that I am using (starting point appears in top left corner) A1 Units Price Cost Part1 275 ? ? Part2 450 ? ? Part3 202 ? ? Part4 260 ? ? A20 <100 <200 <300 <400 <500 Part1 £1.10 £1.70 £1.80 £1.90 £2.00 Part2 £1.90 £2.00 £2.10 £2.20 £2.30 Part3 £1.50 £1.60 £1.70 £1.80 £1.90 Part4 £1.80 £1.90 £2.00 £2.10 £2.20 Appreciate any help Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup not returning correct value | Excel Worksheet Functions | |||
VLOOKUP not returning correct answer | Excel Worksheet Functions | |||
MAX Function not returning correct value | Excel Worksheet Functions | |||
VLOOKUP not returning correct value | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions |