RE: solver
Hi Marc,
The Solver option generates a solution given certain parameters. I will give you any example:
Let us say in A1 there is 50 and B1 is empty.
In C1 using the solver you specific the solution must be 100 to the question A1+B1=100. The computer goes through lots of possible solutions and give you a suggested solution of 50. This is a simple example but with more complicated formula it can be a very useful tool.
I hope that makes sense, if not let me know
Tracy