Excel Function

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
Hi all,

We are looking for an excel expert to help us with a functions/formulas for one of our clients eCommerce solution.

The function we are needing has to link cells AM1 (values in red) to G2, G3, G4, G4, etc. The attached file is just one example of this.

Also, in the functions, there needs to be a way of subtracting a value or percentage from the total linked value. (So if the value in G2 is $40, then the linked value in AM1 is [$40 - $10] $30.

This formula, if possible, needs to be simple enough for us to copy and modify depending on which values/cells we are linking up, as the excel document will have more than 100 values that need linking.

Please let us know if you need any more information.

Thanks for all your help!

Skills required:
Additional Files: web-designs_onlineshoppingexample.xls
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.