| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I use Goal Seek in multiple cells?
My wife is using the goal seek function in Excel. We are trying to figure
out how we copy this function down the column. |
|
#2
|
|||
|
|||
|
Hmmm... In Excel 2003 and all previous versions that I've used, Goal Seek is
not a worksheet function, i.e. it can't be used in a formula. It's a command that you select from a menu, just like File/Close, etc. You have to choose it from the Tools menu and fill in the input information. There's no way to "copy [that] down the column". On Thu, 22 Sep 2005 18:41:02 -0700, "Rey M" <Rey wrote: My wife is using the goal seek function in Excel. We are trying to figure out how we copy this function down the column. |
|
#3
|
|||
|
|||
|
Thanks for the help
"Myrna Larson" wrote: Hmmm... In Excel 2003 and all previous versions that I've used, Goal Seek is not a worksheet function, i.e. it can't be used in a formula. It's a command that you select from a menu, just like File/Close, etc. You have to choose it from the Tools menu and fill in the input information. There's no way to "copy [that] down the column". On Thu, 22 Sep 2005 18:41:02 -0700, "Rey M" <Rey wrote: My wife is using the goal seek function in Excel. We are trying to figure out how we copy this function down the column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
| Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions | |||
Linear Mode
