Somewhat f a vague question. you can just have a list of numbers, then enter
your desired formula next to the list?

perhaps use a VLOOKUP with your list to return the result you want to match?


"Edward" wrote:

Hi everybody,
I have a model that I need to to use what if analysis tool ( if possibile ).
Here is the problem I have a number is cell A2 that is used in some formulas
throughout the worksheet and the output of those formulas are used in other
formulas as input range , after several levels of formuals in different cells
of the worksheet I get to a certain number in cell G100 (it's value depends
on A2). Without changing the value in A2 I want to create a data table that
would output values for different values in A2
--
Best regards,
Edward