Difference between 2 numbers

[Peter100]

I simply want to calculate the difference between two numbers in A1 & B1

 

[sen_edp]

are you kidding ?

 

[Peter100]

No

if A1 = 20 and B1 = 30 then A1-B1 = -10 and I want it to display the difference as being 10
This message was edited by Peter100 on 2002-05-04 17:12

 

[sen_edp]

Hello Peter


try the abs function
Suppose you have the formula in c1

=abs(a1-b1)

 

[Steve Hartman]

=ABS(A1-B1)

 

[Peter100]

Cheers Fellas

I was searcing for Diff or something similar

 

[Brian from Maui]

Why not just =b1-a1?

 

[Peter100]

Because the nest row might have the data reversed and then the problem would be the same

 

[pmchagnon]

Use this:

=IF((A1-B1)<=0,B1-A1,A1-B1)

 

[rarobot]

Use this:

=IF((A1-B1)<=0,B1-A1,A1-B1)

Thank you! This is what I was looking for.