Add two cells and change sign to match third cell

[nxmike]

Hello everyone!!!

I need help on how to sum two cells whatever the sign is and if a third cell is for example positive to result in a positive number.
for example

if the first cell is 100
second cell is -50
third cell is -25
the fourth cell should be -50 (+) -25=-75 but because the first cell is a positive number i want to show me +75(instead of-75)


thanks a lot
im really waiting for someone to help me

Mike

 

[123rickfear]

=if(a1>0,(B1*-1)+(C1*-1),B1+C1)

does that do it?

 

[AlanY]

with -50 in A2 and -25 in A3

try
=SIGN(A3)*(A2+A3)

ignore this, gives wrong result.

RoryA's should work

 

[RoryA]

Welcome to the forum.

Perhaps:

=ABS(B1+C1)*SIGN(A1)

 

[nxmike]

sorry guys i made a mistake..
i want something like =if(a1>0,(b2*-1)*(a1),b2*a1)

what am i doing wrong here?

 

[RoryA]

Can you give a more specific example of what you want if the solutions so far don't do it?

 

[nxmike]

i want to multiply a1*b1 but if the a1 is positive i want the result to always be positive otherways i want to be what it normaly is.

 

[RoryA]

=if(a1>0,ABS(b2*A1),b2*a1)
should do it.

 

[AlanY]

try

=if(A1>0,ABS(A1*B1),A1*B1)

 

[nxmike]

quys it says that the formula contains an error...do you know what it maybe is?