Build Excel file to accept input and calculate simple formula

Job ID: 34297318

Budget: ₹8,000 – ₹50,000 INR

I need an excel file that has roughly 15 values (I will provide names/values) that can take in numeric data and return a value.

Please see example below:


Fence Panels (Cost is $80 per panel) - I need 5 panels.

I need the spreadsheet to allow me to enter the number 5 and it returns a value of $400
I need the similar for all items on the file. At the bottom I need to be able to add all the fields together and have a total.

Once we have a total I need to computer 7% tax on the total amount.

Will need a quick turn around.
Related categories: Visual Basic Data Processing Data Entry Excel