Comicfly,

It sounds like using a DataTable would help. Search for 'data tables' in
excel help and it will give you more guidance - essentially you input your
10-string formula as per normal - and then extend it based on a number of
different one or two variable scenarios.

In your case you would have a one variable data table based around changing
0.2 to 0.21, 0.22 etc.

Try that avenue and let me know if you need any more information.

Regards

Jim


"Comicfly" wrote:

I have a worksheet that has 10 formulas that feed off each other reaching one
answer. I would like to generate a table by changing one of "feed" cells to
the worksheet. I would change that "feed" number by 0.01 between the range
of 0.2 to 0.5. I would like to see the results based on each change in a
table. I was going to use the Scenario function, but I have to manually
input each 0.01 number in to generate / summarize a table. Is there a better
/ easier / faster way?

Thanks
--
Comicfly