Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

FORMULA ON GOAL SEEK

CAN YOU GIVE ME FORMULA FOR GOAL SEEK

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

See http://office.microsoft.com/en-us/excel/HP052038941033.aspx for definitive example. Thanks for rating FixYa!

Posted on Apr 21, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi, My formula will not give me the correct sum when I drag it down into new columns even though the formula is correct. Please advise


What happens if you copy the formula from one cell and paste it into another? Sometimes formulas don't drag correctly. This can happen especially when you have more complex formulas. Another thing that can throw off the drag and drop copying of formulas are hidden rows or columns.
If a copy paste doesn't fix the issue than reply with the exact formula and a snippet of your data so I can troubleshoot it better.

Apr 04, 2017 | The Computers & Internet

1 Answer

Organizational Development specialists focus on what ?


It is a focus mainly on what it sounds like: the development of organizational patterns and systems for employees and business processes. Overall, it is a position that seeks to help a company be more efficient at reaching its business goals. The Wikipedia article is a good place to start if you want a bit more information.
Organization development

Aug 17, 2014 | Computers & Internet

1 Answer

What does geopolitics actually mean?


Basically geopolitics means the study situations where politics are regulated in different manner for many reasons and purposes and those are basically depending on the geography and demographics of a country or region and more also the economical facts and impacts. You can say this a geopolitics as a way or wish to rule a territory with diplomatic strategies and political policies for to avail the fruits and to reveal the hidden sources. Taking control of any particular territory is the prime goal of geopolitics. You may know about meta geopolitics which indicates the traditional and test book concepts & formulas of geopolitics.

Sep 22, 2012 | Geo Cars & Trucks

1 Answer

Wat is special product


Here, We deal with Some Special Products in Polynomials.

Certain products of Polynomials occur more often
in Algebra. They are to be considered specially.

These are to be remembered as Formulas in Algebra.

Remembering these formulas in Algebra is as important
as remembering multiplication tables in Arithmetic.

We give a list of these Formulas and Apply
them to solve a Number of problems.

We give Links to other Formulas in Algebra.

Here is the list of Formulas in
Polynomials which are very useful in Algebra.
Formulas in Polynomials :

Algebra Formula 1 in Polynomials:

Square of Sum of Two Terms:

(a + b)2 = a2 + 2ab + b2
Algebra Formula 2 in Polynomials:

Square of Difference of Two Terms:

(a - b)2 = a2 - 2ab + b2
Algebra Formula 3 in Polynomials:

Product of Sum and Difference of Two Terms:

(a + b)(a - b) = a2 - b2
Algebra Formula 4 in Polynomials:

Product giving Sum of Two Cubes:

(a + b)(a2 - ab + b2) = a3 + b3
Algebra Formula 5 in Polynomials:

Cube of Difference of Two Terms:

(a - b)3 = a3 - 3a2b + 3ab2 - b3 = a3 - 3ab(a - b) - b3
Algebra Formula 8 in Polynomials:


Each of the letters in fact represent a TERM.

e.g. The above Formula 1 can be stated as
(First term + Second term)2
= (First term)2 + 2(First term)(Second term) + (Second term)2

Jul 02, 2011 | Computers & Internet

1 Answer

No Driver for Wimdows XP


What sort of driver:

* Morgan Freeman (from "Driving Miss Daisy")

* Danica Patrick (the GoDaddy spokes-person)

* Emerson Fittipaldi (Formula 1)

* Don Garlits (Top Fuel 1/4-mile drag-racer)

are you seeking?

Dec 20, 2010 | Computers & Internet

1 Answer

Formula for excel to calculate years of giving.


In AJ3 thru BT3 put a number. Doesn't matter what number. Then type the following formula into a cell and instead of pressing enter press and hold control, then press and hold shift, and then press enter, and then release all the keys.

=COUNT(IF(NOT(ISBLANK(AJ2:BT2)),AJ3:BT3)



Jun 03, 2009 | Haier Chest Freezer HNCM070E

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Explain brief about Goak Seek Command, Solver, Sceanerios


Goal Seek Solver and Sceanerios are a Part of What if Data Analysis Tools.
Goal Seek find the Expected Change in terms of value to a calculated Items.
For Example if you have a sales data for the year 2007 where Profit is 350000 and you want to make it 500000 for the year 2008 so what changes you will do in Product cost or Product Price this you will find with Goal Seek. It is also known as Back calculation. It has some restrictions which is overcome by Solver. But before doing this type of calculation use Sceanerios to store different Calculated values using Goal Seek and Solver. You dont have to add these values in different sheets all the values stored as a sceanerios. so You can show different Predections to the customers without moving around the Sheets.

Nov 17, 2008 | Microsoft Computers & Internet

1 Answer

An IF Then question


Assumed I have this sheet below:
   |   A       |     B
=====================
1 | SALES   |   GOAL
2 |       3000 | =IF(A2>2999,"YES","NO") -> copy too all cell below
3 |       2000 | =IF(A3>2999,"YES","NO")
4 |       2999 | =IF(A4>2999,"YES","NO")


Will be displayed as:

   |   A       |     B
=====================
1 | SALES   |   GOAL
2 |       3000 | YES
3 |       2000 | NO
4 |       2999 | NO

Aug 04, 2008 | Microsoft Windows 98 for PC

1 Answer

About goal seek


Try going here for the basics and sample files. http://office.microsoft.com/en-us/excel/HA012240771033.aspx

To get more details and help I would order consider ordering the book: http://www.microsoft.com/mspress/books/5599.aspx

Jun 12, 2008 | Microsoft Office Home and Student 2007...

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

396 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...