Custom VBA what-if scenario function?

[Kelvin Stott]

Hi, I need a non-invasive custom VBA "what-if" scenario function as follows:

WHATIF(Output_Cell, Cell1, Value1, Cell2, Value2, ...)

This would give the hypothetical value of the output cell if each of the given input Cells 1 to X were changed to the respective scenario values 1 to X, but without actually changing the values in those input or output cells. It should just return the hypothetical output value (i.e., solution) wherever the function is used, for example in another cell.

Is this possible, and does some code exist to do this already?

Many thanks,
Kelvin

 

[Kelvin Stott]

Is this possible, please anyone?

 

[Joe4]

I think your question is too generic. It might be best to walk us through an example of exactly what you want to happen.

Some important details include?
- Where exactly do you intend to use this function? In a cell on your sheet (like other Excel functions), or in VBA (like other VBA functions)?
- What exactly is the calculation being performed?
- Please provide some sample data and expected output.

Pasting some images may be helpful. You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.