Writing formula/setup in excel
- or -
Post a project like this1831
€40(approx. $43)
- Posted:
- Proposals: 22
- Remote
- #2342942
- Awarded
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
Top-Rated Project Manager & Procurement Officer (Knowledgeable in MS Project)
Quezon City
WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT
New Delhi
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
Regensburg
|BPR|Research|Marketing|Translations|Design|Technical Support|Assistance|more... much more...
Quilmes
190114264318098984264240626359742612223260070325982912561066254377824785852454441
Description
Experience Level: Entry
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.
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.
Sam V.
100% (104)Projects Completed
75
Freelancers worked with
43
Projects awarded
53%
Last project
30 Jun 2023
Sweden
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies