Hi please if anyone can help me. I want to make my model so the use can change formula in cell without all cells updating to same formula. How can I do this? When I try to change a formula in output it will change formula for all output in that range. This is not flexible enough and I want to change some cells to make adjustment. Thank you kindly. Wei-Mei
Hi Wei Mei,
The issue you have is that you've entered a value into an output cell. The software has interpretted this as you wanting the 'calculation' of that cell (and all cells in the cell block) to be just that value.
If you wish to make adjustments to certain cells individually, then you will need to add an explicity assumption cell block to the module you are entering the adjustment to. The system is designed for consistency (and best practice) and entering adjustments to individual formulae goes against this, assuming you don't want the adjustment in all cells!
Whereabouts in your model were you attempting to put an adjustment through? The other thing to note is that entering adjustments into the financial statements of a model will typically result in the balance sheet being unbalanced.
Cheers
James