Nikki has attended:
Excel Advanced course
Goak seek
I'm trying to use the goal seek function and have followed the instructions provided in the guide.
I have got as far as entering the "set cell", "to value" and "by changing cell". When I click "ok" it comes up with the error message "cell must contain a value", but all the cells I have selected do have values in them.
Thanks for your help.
RE: Goak seek
Hello Nikki,
Thank you for your question regarding using Excel Goal Seek.
There are only 2 rules here:
1) Most important rule when using Excel Goal Seek is that the Set cell MUST have a formula in it.
2) The By Changing Cell must of course have a value in it.
If you are following the above rules, then it must work. If you still have problems then send me a sample file with the issue you are trying to work with and I'll take a look at it and come back to you.
My email is rl@stl-training.co.uk
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
