Please help. Can't see the error.

[momchil.vladov]

Hi there,
Please tell me where is my mistake.

Simply what I want is:
If A1 is bigger than B2, than A1-B2=B3
If A1 is lower than B2, than B2-A1=B3

I am using this formula: =IF(AND(A2>B2);(A2-B2));IF(AND(A2<B2);(B2-A2)) and it tells me #VALUE!

Thank You very much

[Tony Valko]

Try this...

=ABS(A1-B2)

[Debraj Roy]

try this..

Please Login or Register  to view this content.