Working with percentages

Try this:

Please Login or Register  to view this content.

Copy that formula shown column B from B2. Format the cell as percent.

Try this,

B2: =(A2/A1)-1

JB, one of us, probably me, has it wrong

You can either double click the bottom right corner of B2.
Or select B2, Hold the SHIFT and select the last cell in column B to have ad value and then use CTRL+D to fill down.

Originally Posted by Andy Pope

JB, one of us, probably me, has it wrong

Heh, debatable. Technically both formulas are correct, depending on your mathematical upbringing. Formatted to 1000ths, this is the result of the two different formulas. Though the results are different, if the table is mostly referential, I wouldn't consider it important. If the results are used to create payments of some kind, then the debate between the two formulas would need to be resolved.

Please Login or Register  to view this content.

I think yours is probably the better results.

=====

Originally Posted by nicodam

How do I get it to take calculate the entire column, without me having to plot in every single number?

Do you mean a formula that takes the first value (A1) and the last value (whereever it may be) and gives you the percentage difference?

Using Andy's original formula, this will give you the whole column answer:

=LOOKUP(9.9E+307,A:A)/A1 - 1

These values give a more dramatic variation

Please Login or Register  to view this content.

Yep. Yours is the correct one.