Formula with absolute value?

[itexet]

x=...
y=...
5*(x-y)=
if "x" and "y" are with different signs (-/+ or +/-) the formula should be like that,
but if "x" and "y" are with same signs (-/- or +/+) in the brackets should stay only one value with his sign - the absolute value of (x and y).
How should it look like?

 

[Joe4]

Welcome to the Board!

I am afraid I am not entirely clear what you are asking here:

but if "x" and "y" are with same signs (-/- or +/+) in the brackets should stay only one value with his sign - the absolute value of (x and y).

What don't you actually show us what you mean by giving us a few real examples, where you give us real values for x and y and show what should happen in each case?

 

[itexet]

Welcome to the Board!

I am afraid I am not entirely clear what you are asking here:

What don't you actually show us what you mean by giving us a few real examples, where you give us real values for x and y and show what should happen in each case?

If we have different signs:
x=1
y=-2
The formula should look like this: 5*(1-(-2))

If we have similar signs:
x=-3
y=-6
The formula should look like this: 5*(0-(-6))
We take the absolute value.

One more example:
x=-3
y=-1
formula: 5*(-3-0)

 

[Joe4]

I think you are mixing up your mathematical terms.
Absolute value simply means if the number is negative, change it to positive. So the absolute value of -6 is 6.

It looks like you are are taking the maximum of a number and 0, i.e.
the maximum of -3 and 0 is 0
and the maximum of -1 and 0 is 0

So, are you always applying that maximum to the larger of the two values?
What if you had x=3 and y=6?
Then what should the formula look like?

 

[itexet]

I mean the bigger number with his sign:
x=-2; y=-6 -> the bigger is -6

If x=3 and y=6 -> 5*(0-(+6))

 

[Joe4]

x=-2; y=-6 -> the bigger is -6

Mathematically speaking, -2 is bigger than -6.
Maybe this is where the absolute value comes in, when you mean the absolute value of -6 is greater than the absolute value of -2.

If x is in cell A1, and y is in cell B1, try this formula:

=IF(OR(AND(A1>0,B1<0),AND(A1<0,B1>0)),5*(A1-B1),IF(ABS(A1)>ABS(B1),5*A1,5*(-B1)))

However, you haven't said what should happen if one of the values is zero, or they are both the same.