I'm trying to create an indicator that would show the percentage change in the value of a single cell after some of the input variables that the value in this cell's formula is dependent upon change. I'm aware that it is possible to create columns of previous/current values and to calculate the percentage error that way, but it would be really useful if there was a way to recall the previous value of the cell and compare it with the current/new value (ideally in the form of a percentage error, but I'll take anything :P). If anyone has any suggestions on how I should proceed I'd be so grateful. Btw I'm using Excel 2013. Cheers