From the discussion applying data filters
Mon, 18 Aug 2008 10:03:05 -0000
HELLO NITIKA, I HAVE ANSWER OF ALL THE QUESTIONS U HAVE POSTED. FIRST WHAT IS GOAL SEEK? GOAL SEEK IS USED WHEN WE HAVE A RESULT AND WANTED TO CHANGE THAT TO THE DESIRED RESULT. TAKE A EXAMPLE OF THE SUM OF TWO NO. SUPPOSE U HAVE A TOTAL OF 5 IN C1 CELL WHEN 2 IS PLACED IN BOTH THE PREVIOUS CELLS. AND NOW U WANT TO CHANGE THE TOTAL TO 7 BY CHANGING THE CELL A1 AND DOES NOT KNOW WHAT WILL BE THE VALUE WHICH WILL BRING THE DESIRED RESULT. AT THIS STAGE THE GOAL AND SEEK OPTION WILL HELP. THIS WILL ASK THE VALUE U NEED AND THE CELL U WANT TO CHANGE FOR THE DESIRED RESULT.
IF U STILL HAVE A PROBLEM I WILL SOON POST A CHAPTER ON GOAL SEEK PLEASE GO THROUGH THAT ONE.
AND REMAINING QUESTIONS WILL BE ANS LATER.