Excel 2010, GOAL SEEK

By -
Hiiiiiii , and a very good day to all my readers. I have been receiving queries related to Advanced Excel features including, GOAL SEEK, SCENARIO, PIVOT TABLE, SUBTOTAL, FORMULA etc. We shall be discussing each and every feature of Advance Excel in Detail. Firstly we'll be learning the GOAL SEEK Feature


Goal Seek

Goal Seek is used to determine the value of  any input cell(cell being used in the formula) new value for formula cell is known. Suppose we have following table available with us having details of employees along with Salary figure and computed bonus value as 12 % of Salary

Here in the above table, if you would like to determine the new Salary for employee name "SOFT" , for a new Bonus value of 4100 (where Bonus is calculated as 12 % of salary) . To do so,follow the steps mentioned below,
  1.  Place cell pointer in formula cell(in our case, Bonus Cell)
  2. Data > What If Analysis> Goal Seek
  3.  Goal Seek dialog box appears in which supply following details

Understanding the details asked under Goal Seek
  1. Set Cell: Specify the Address of Formula Cell
  2. To Value: Mention the new value of Formula Cell for which we want to calculate the new value of Input Cell(In our case , it is 4100 for Bonus Cell)
  3. By Changing Cell : Specify the Address of cell whose new value is to be determined (In our case, address of Salary Cell)
  4. Click OK to determine whether EXCEL has found a solution or not. 

In case the formula is not related to specified cell, EXCEL may not have found a solution, you may receive the Error Message Window Instead


I hope this will work for you. Bye, and Enjoy Reading As Always....

Comments

Post a Comment

Popular posts from this blog

Understanding Working of Text & Binary File in C

By -
Text file // assume that you have already created a   program file first.c and you want to display its contents on screen Ex 1: Program to show contents of any TEXT File on screen #include <stdio.h> main() {             FILE *fp;             char ch;             clrscr();             fp=fopen(“first.c”,”r”);             if (fp==NULL)             {                         printf("Cannot open file");                       ...
Read more

List of C Programs that makes u understand concepts in an easy fashion(Part1)

By -
A very Good Day to all my Readers, Today i received a Query Regarding solutions towards common C programs, using which one can understand the concepts of C in easy Way. So here is a complete Ready To Use Solution Kit for you reader Program 1 Program to print A to Z along with equivalent ASCII Value main() { int ch,c; clrscr(); c=1; ch=65; printf("Alphabet\t\t ASCII Value\n"); while(c<=26) { printf("%c",ch); printf("\t\t%d",ch); printf("\n"); ch=ch+1; c=c+1; } getch(); } Program 2 : Write C program to calculate Factorial of given Number main() { int fact,num; clrscr(); printf("Enter Any Number:"); scanf("%d",&num); fact=1; while(num>=1) { fact=fact*num; num=num-1; } printf("Factorial is %d",fact); getch(); } Program 3   Program to calculate Sum of first n natural numbers #include <stdio.h> main() { int n,t...
Read more

Starting C : A series of Chapters to learn C

By -
So far you have gone through the solved examples in my Blogs.I have received a lot of emails demanding “Step by Step learning of C Language'” in easy to understand language with illustrative examples. So here we go…. Chapter 1: Basic C Program Structure Prior to learning,the basic program structure, here are some rules to be followed while writing program, * C being case-sensitive ; entire program should be typed in Small Case letters(By entire program, we mean all the commands and keywords being used in the program). * Each new statement should begin with a new line. * To mark the finishing of each statement, place a semicolon(;) at the end of statement. The Basic C Program Structure #include <headerfile.h>                      (1) main()                       ...
Read more