ExcelBanter - Formulas

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulas (https://www.excelbanter.com/excel-worksheet-functions/29597-formulas.html)

Janelle

Formulas

In Excel, what is the formula to calculate the difference or change in
numbers (delta) between cells?

JE McGimpsey

one way:

=B1 - A1

In article ,
"Janelle" wrote:

In Excel, what is the formula to calculate the difference or change in
numbers (delta) between cells?

SVC

If you are looking for just the difference, use =A1-B1.
If you want the absolute difference, use =ABS(A1-B1)

"Janelle" wrote:

In Excel, what is the formula to calculate the difference or change in
numbers (delta) between cells?

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