• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula needed for showing result while value of any cell is changed in the model

rashed125du

New Member
I prepare complex financial models. In the models, sometimes I want to know the result (projected net profit) if any cell containing a formula or value is changed while keeping the original result intact (to be shown in another sets of cells, and this is not a data table problem). I want to know if there is a formula that can show the result (like data table) if certain inputs are changed.

In the sample file, I want answer in row 8 if (for an example) value in B11 (which is a formula) or B12 (which is a value) is changed. But I want to keep the original result intact in row 7.

I have also posted in other groups -
https://www.mrexcel.com/board/threa...-of-any-cell-is-changed-in-the-model.1118657/
https://www.excelforum.com/excel-pr...cell-is-changed-in-the-model.html#post5249534
 

Attachments

  • Example.xlsx
    9.4 KB · Views: 2
Last edited:
Back
Top