# Replace a formula input w/ a series of inputs & display respective series of outputs

1. ## Replace a formula input w/ a series of inputs & display respective series of outputs

I am working on a financial spreadsheet. One cell is a formula that equals the profit or loss of a given trade based on a number of assumptions.

One assumption in another cell (let's say B35) is the final stock price (i.e. in a few months...a prediction). However, I would like to create a column that is a series of potential final stock prices (maybe 100 prices or so) and then have the cell right next to each of those assumptions equal the profit/loss that the trade would then equal. I don't know how to take all these new assumed stock prices and plug them into the equation so my new profit/loss is based on the new assumption. I don't want to have to change the assumption each time. I want a bunch of assumptions and then the output for each of those assumptions.

This should be pretty simple to do but I don't know how to do it.

Thanks

Update: I posted my worksheet. Right now I input my assumed final stock price into B3 and then the total profit/loss from the trades (up to 4 calls, 4 puts, 1 long and 1 short) in cell B35.

However, I'd like to have this final profit/loss read out in cells B43:B443 based on each cell's respective assumed stock price (the cell right next to it in column A). e.g. since A97 is 13.50 and the two trades currently loaded in my worksheet would then equal a 1,722.22 profit, cell B97 should be a formula that reads 1,722.22.

thanks for any help

2. ## Re: Basic question

Probably easiest to post a sample workbook.

And you'll probably be asked by the moderators to change the title of the post to something more meaningful (as per the rules of the forum)

Regards

3. ## Re: Replace a formula input w/ a series of inputs & display respective series of outp

Any ideas? Sorry for the lengthy post and I think my question is pretty basic but I still can't figure it out.

Any help would be much appreciated. Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1