Complex Excel Price Calculator
Closed - This job posting has been filled and work has been completed.
We need to add functionality to the existing Price calculator. It is very complex and will need understanding before applying.
The attached pdf gives the outline of work required and would be relatively easy for someone who has vba skills, however the task is to understand how the calculator works and how it references tables to arrive at the calculation.
I will only interview contractors who answer these questions:
1.If hired today, when would you complete this task?
2.Are you very familiar with INDEX/MATCH combination to look up tables?
3.Please provide me with the reference at the end of the pdf.
Look forward to hearing from you.