Finishing A Google Sheets Spreadsheet Calculator

Completed Posted 5 years ago Paid on delivery
Completed 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.

Excel Excel VBA

Project ID: #18349998

About the project

5 proposals Remote project Active 5 years ago

Awarded to:

ianfosgate23

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

$15 USD in 1 day
(138 Reviews)
6.5

5 freelancers are bidding on average $32 for this job

elqueabandona

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

$30 USD in 1 day
(206 Reviews)
6.8
MohsanEijaz

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

$55 USD in 1 day
(69 Reviews)
6.1