ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do in perform trial and error method in excel? (https://www.excelbanter.com/excel-worksheet-functions/204904-how-do-perform-trial-error-method-excel.html)

Raajesh

How do in perform trial and error method in excel?
 


David Biddulph[_2_]

How do in perform trial and error method in excel?
 
Your first error is posting your question only in the subject line, when it
should have been in the message body.

To get to your question:

Try something
Begin loop
See whether you like the answer
If answer OK then End, else change something and return to start of loop.

Hint:
Unless you understand the question well enough to know roughly what to try,
and roughly what to change if the first solution is unsatisfactory, your
chances of getting a successful result are slim.

If you want to do this in a slightly more scientific manner, look at the
Goal Seek and Solver tools.
--
David Biddulph

"Raajesh" wrote in message
...





All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com