I have been tasked with trying to create a spreadsheet that will allow me to ‘calculate’ a recipe for a process at work.
Essentially, i have roughly 4-5 different variable categories, which each having around 10 or so subsections that should be used as a formula to calculate a final value (a prediction to be used in production).
I have tralled the web trying to find a solution for this but have not been able to come up with anything.
Please could someone tell me if this is even possible!
By: Craig Dawson