=A2-A1 if answer is negative =A1-A2

[dixon1983]

Hi,
Can anyone help with this?
I would like to put a formulae in a cell that calculates A2-A1 but if the answer returned is negative to calculate A1-A2.

Can this be done??

Thanks in advance

 

[Richard Schollar]

Hi

How about:

=ABS(A2-A1)

Best regards

Richard

 

[Bob Rooney]

=ABS(A2-A1)

 

[bsnapool]

This should do it:

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

 

[bsnapool]

Learnt another formulae...

Thanks

 

[dixon1983]

Thanks all.

The only problem is is that I am subtracting one date from another than adding one onto the answer.

E.g if the date is 10/10/06 and the other date is 10/10/06 the answer would be 1.

So the formulae I use is =(A1-A2)+1 and if negative I want =(A2-A1)+1.

=ABS(A1-A2)+1 doesnt return the same value as (A2-A1)+1.

Does anyone know a way around this??

Thanks

 

[yee388]

=ABS(A1-A2+1)

 

[GlennUK]

=ABS(A1-A2)+1 doesnt return the same value as (A2-A1)+1.

... yes it does, when A2 is larger than A1. Give an example of when you think this wouldn't be the case.

 

[yee388]

... yes it does, when A2 is larger than A1.

I believe the original reason for the post was because A2 is not always the larger number, and he needs one forumula for both situations.

 

[GlennUK]

If A2 is not the larger number then (A2-A1)+1 would produce an incorrect answer. The formula provided copes with both situations, as far as I can see. I want an example of when:
=ABS(A1-A2)+1
doesn't do what is required.