Finishing A Google Sheets Spreadsheet Calculator
$10-30 USD
Paid on delivery
I'm looking to create a google sheets-based calculator for the purpose of computing numerous factors from an online game that I play. The spreadsheet is 99% done, but I'm completely stuck on the last part.
Essentially what the calculator does is compute the total cost and in-game "happiness" level based on which property and which individual property upgrades are chosen on a series of drop down menus.
I would like to add an additional factor- two game "perks" that give either a 10 or 20% discount on an individual upgrade.
However I cannot seem to be able to figure out how to incorporate the data from a second drop-down menu into the main cost column, in which each cell is linked to it's own drop-down menu.
Here is the link to the spreadsheet if you want to take a look at it:
[login to view URL]
Essentially I want column H to automatically apply the "perks' if they are chosen by the dropdown menu, instead of having them as a separate column.
Project ID: #18349998
About the project
Awarded to:
Hi there! I have checked your spreadsheet and would like to help apply the dropdown menu which will auto-calculate the value of the column H based on the selected perk. Feel free to send me a message to clarify if I di More
5 freelancers are bidding on average $32 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfe More