Show last know calulation

[pigsfoot]

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

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

What is your formula in the top row of the % Diff column?

In any case, try (check table name)

=LOOKUP(9^9,Table1[new visitors],Table1[% Diff])

 

[pigsfoot]

Hi, Excel version has been added, thanks i wasn't aware i could do that,

The formula for the % Diff column is simply - =([@Total]-E2)/E2 ( formtted as % )

Thanks

 

[Peter_SSs]

The formula for the % Diff column is simply - =([@Total]-E2)/E2 ( formtted as % )

Thanks. Unfortunately I do not know which is column E or at least what is in E2, but in any case I edited my previous post to make a suggestion. Did you see that formula?


BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Thanks for updating your profile.

 

[pigsfoot]

Perfect, thats done it thanks @Peter_SSs

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.