Archive: Writing formula/setup in excel

Budget 44$ per month

Posted: 5 years ago

Closed

Description: We are a publishing house.
We have an excel sheet with a Dropdown List that shows different Book Formats (BF).
A book Production Price (PP) has the formula:
PP = (Cost Per Unit)+ Pagenumbers*(Cost Per Page)
For different BF we have different (Cost Per Unit) and (Cost Per Page) in four different countries. These are listed in a table next to the source list of the Dropdown List.
We need a formula/setup that when we select a certain BF, then the associated PPs are automatically calculated and shown in the PP cells for the book for each country.
It is however important that the formula is easy and simple and implemented in a comprehensive way so that we can understand and change it in the future.
Look hearing from you.

Preferred UK, US or EU based experienced excel specialist.