Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to use Equations?

Posted on 2008-10-20
3
Medium Priority
?
1,488 Views
Last Modified: 2012-06-27
I found how to solve equations with Excel.
But don't have any idea how to do it with Numbers.
Example:
2x+4=800
x=?
0
Comment
Question by:3dcooking
3 Comments
 
LVL 5

Expert Comment

by:PaulKeating
ID: 22757106
The value x is in B1
Set some cell to this formula
=2*B1+4
Highlight that cell and select Tools | Goal Seek. It will prompt you Set cell: (cell you highlighted)  To value: enter 800 By changing cell: enter B1, because that is where x is.
Press OK. Excel will find the value of x (=398) and if you press OK it will put 398 in cell B1.

goalseek.bmp
0
 

Author Comment

by:3dcooking
ID: 22757590
That is a solution for Excel.
But is there a possibility to substitute Goal Seek on iWork "Numbers" on Mac?

0
 
LVL 5

Accepted Solution

by:
AJVienna earned 500 total points
ID: 22759898
According to the document below and my own experience Numbers does not support this:
http://discussions.apple.com/thread.jspa?messageID=8210389

If you seek a free solution which does you can use openoffice 3.0
www.openoffice.org
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question