Price escalation

[Martynw1988]

Hope someone can help me with this one. So easiest way to describe it would be, imagine I want to increase my sales price of my apples. Apples vary in cost so I have hundreds of different rates for these apples. I want to increase the price of the apples if the electricity for the building goes up so I know my base sales price for the apples and I know my base electricity cost per unit for the building.

If the price of the electricity goes up from the base rate by 3 pence per unit I want to increase the price of my apples by 1% across the board. this rate would fluctuate so if the price of electricity goes down by 3 pence the sales price goes down 1%. if the price goes up by 6 pence then rate increase would be 2% and so on.

So base cost = 100 base sale price = 10.00 IF base cost is 101 new sale price = 10.30

Any help or advice would be much appreciated.

[jme1013]

Sorry, but you didn't ask an Excel related question.

What are you wanting to accomplish?

[Martynw1988]

Sorry if i wasn't clear, i would like a formula that says. Base cost Cell A1 Sales prices Cells E7:O29 IF Cell A2 is >3 above base cost increase sales prices of E7:O29 by 1%

[AliGW]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.