Calculate for three variables

**SRodin** · 01-09-2012, 12:20 PM

I have a problem that seems simple at first but is confusing me. Any help will be very gratefully received.

I have the following data;

No. of parts per load
Price per part
Surface area of each part

This is to help me work out the price we should be paying for a part depending on the size of the part and the number of parts in a load.

I have already worked out averages from the data available; there are 3030 parts per load, the surface area of each part is 2146(mm²) and the price per part is €0.6431.

I want to calculate the price if the surface area of the part is different and/or the load is different (e.g. if the surface area is 2000mm² and the load is 1500 pieces).

Can anyone help me with this calculation?

Many thanks
Steve R

**NBVC** · 01-09-2012, 12:23 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST