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

[rashed125du]

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.

 

[jasonb75]

Duplicate of Complex Formula related Problem

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).