Forum Discussion

elteluk's avatar
elteluk
Copper Contributor
Mar 09, 2020

difference between two columns

is there a simple formula i can add and use to calculate the difference in value of two columns showing percentage and actual difference? excel

Formulas and Functions

1 Reply

  • Savia's avatar
    Savia
    Iron Contributor
    Mar 09, 2020
    You can calculate the difference between the columns with e.g. =SUM(A1:A100)-SUM(B1:B100). And you can divide that by whichever basis column you please to get the percentage difference - e.g. (SUM(A1:A100) - SUM(B1:B100))/SUM(A1:A100)

Resources