ExcelBanter - Difference between two numbers

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

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

- - Difference between two numbers (https://www.excelbanter.com/excel-worksheet-functions/263300-difference-between-two-numbers.html)

Pam

Difference between two numbers

I have two columns, each with numbers in them. All I want to do if find the
difference between these two numbers. Don't want whether negative or positive
-- just the difference. Is this possible?

Glenn

Difference between two numbers

Pam wrote:
I have two columns, each with numbers in them. All I want to do if find the
difference between these two numbers. Don't want whether negative or positive
-- just the difference. Is this possible?

=ABS(B1-A1)

Gary''s Student

Difference between two numbers

With values in columns A & B, In C1 enter:

=A1-B1 and copy down
--
Gary''s Student - gsnu201002

"Pam" wrote:

I have two columns, each with numbers in them. All I want to do if find the
difference between these two numbers. Don't want whether negative or positive
-- just the difference. Is this possible?

All times are GMT +1. The time now is 04:33 AM.