Goal Seek

I've recently started using numbers and wanted to use the goal seek function that is available in excel work sheets under tools .

Is there any function within numbers that can perform the same task ie If you have an answer cell that that has a formula that is a multiplication of two cells and you know the answer you want from the operation and you can get to your target figure by varying one of the multipier cells.

Any help gratefully received, I have n't got much hair left to tear out User uploaded file( I did n't a t the start but thats beside the point)


Thanks

imac 20, Mac OS X (10.5.4)

Posted on Sep 9, 2008 11:07 PM

Reply
3 replies

Sep 10, 2008 5:49 AM in response to Peter Kavanagh

Peter,

Numbers doesn't reproduce all the Excel functions, and I'm afraid that Goal Seek is one of the missing. You can, however, resort to algebra to save the remaining strands of hair. As in: if Z = X * Y, then Y = Z / X. But I'm sure you knew that. If you want to have some fun, format one of your inputs as a slider control. In this example, 2500 is the goal, X is on a slider, and Y is calculated.

User uploaded file

Am I on the right track?

Regards,

Jerry

Sep 10, 2008 7:05 AM in response to Peter Kavanagh

No need to tear your hairs.
It would be more useful to enter the Help and search for the keyword "functions" which would give you a list of available functions.

It seems that some users wrongly imagine that Help of User Guide are written to fill Hard disks. The truth is that they are built to give use useful informations.

+-+-+-+-+-+-+-+-+

Worried Life Blues 2008

Discussions

+Apple Discussions, launched in August, 2000, have grown rapidly in usage and features. The main features include personalization, subscription capabilities and email capabilities. _For information on how to use Discussions, please visit the Discussions Help Page_. Cookies should be enabled and an Apple ID account is required if you would like to contribute to the discussions.+

+*What is Apple Discussions and how can it help me?*+
+
Apple Discussions is a user-to-user support forum where experts and other Apple product users get together to discuss Apple products. … You can participate in discussions about various products and topics, find solutions to help you resolve issues, ask questions, get tips and advice, and more.+
+_If you have a technical question about an Apple product, be sure to check out Apple's support resources first by consulting the application Help menu on your computer and visiting our Support site to view articles and more on our product support pages._+

+*I have a question or issue*—+
+how do I search for answers? _
It's possible that your question or issue has already been answered by other members so do a search before posting a question._ On most Apple Discussions pages, you'll find a Search Discussions box in the upper right corner. Enter a search term (or terms) in the field and press Return. Your results will appear as a list of links to posts below the Search Discussions Content pane.+

+Search tips are available here:+
+ http://discussions.apple.com/help/search-tips.html+

+-+-+-+-+-+-+-+-+

Yvan KOENIG (from FRANCE mercredi 10 septembre 2008 16:05:36)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Goal Seek

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.