I have always contented myself with using Goal Seek, which has served me proud. I have been told that Solver add-in is much more powerful, and it *may* perhaps be the right tool for this job. Never having used Solver before I have no idea whether it would help with this problem. Certainly in this case Goal Seek is not up to the task.
I have an employee payslip. It is a really complicated one. "Gross" is made up of about half a dozen entries, Some of them are negatives that contra some of the positives. There is about another half dozen categories of deductions, over and above the tax and employee's NI. And at the bottom there are figures for "taxable pay" and "NIC-able pay" for the period. The individual entries that build up to make the taxable and NIC-able pay are not separately identified, but I need to work out which count and which do not (they are not very helpfully labelled, with acronyms and jargon all over the shop). The possible permutations are large in number but ideal for a computer to work out by brute force.
Any suggestions as to how to automate this? Let's start with whether Solver would do the job.
With kind regards