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
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
Last edited: