ExcelBanter - Formula for percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for percentage (https://www.excelbanter.com/excel-discussion-misc-queries/27895-formula-percentage.html)

Tugger

Formula for percentage

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

Niek Otten

=(B1-A1)/A1

Format as %

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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

galimi

Tugger, the formula is (Col2/Col1)-1. This will reflect the change from the
first column to the second.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758

"Tugger" wrote:

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

All times are GMT +1. The time now is 08:06 PM.