Solved

How to use Equations?

Posted on 2008-10-20
3
1,388 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 125 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now