Hi,
I have a small table that calulates % diferences and i want a cell at the bottom that shows the last actual calculation as some cells would not of been filled in yet
So at the bottom of % Diff column i just want a cell that shows the last calulation, in this case it would be 5% and then as more data is added that cell value will update.
The only way i could thik of doing it would be via alot of nested IF statments using the total column as check against 0 but presumably there is a better way.
I hope that makes some sense
Many Thanks
I have a small table that calulates % diferences and i want a cell at the bottom that shows the last actual calculation as some cells would not of been filled in yet
So at the bottom of % Diff column i just want a cell that shows the last calulation, in this case it would be 5% and then as more data is added that cell value will update.
The only way i could thik of doing it would be via alot of nested IF statments using the total column as check against 0 but presumably there is a better way.
I hope that makes some sense
Many Thanks