Formula for percentage

Tugger · May 26, 2005

Can anyone tell me the formula to automatically calculate the % increase or %
decrease between the values in the two preceding columns?

Niek Otten · May 26, 2005

=(B1-A1)/A1

Format as %

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

galimi · May 26, 2005

Tugger, the formula is (Col2/Col1)-1. This will reflect the change from the
first column to the second.