Need help with a formula

P

Pat

I am having trouble with a subtraction formula, Hoping someone can help.
A2 is -200
B2 is 100
C2 needs the formula
What I have is =A2-B2*sign(A2) which works until A2 is 0, then it doesn't
subtract the cells, C2 becomes 0
Can anyone help with this formula.
Thanks
 
R

Ron Rosenfeld

I am having trouble with a subtraction formula, Hoping someone can help.
A2 is -200
B2 is 100
C2 needs the formula
What I have is =A2-B2*sign(A2) which works until A2 is 0, then it doesn't
subtract the cells, C2 becomes 0
Can anyone help with this formula.
Thanks
Click to expand...

What are you trying to accomplish with this formula?

Perhaps if you give examples of the various contents of A2 and B2 and tell us
what you want to see as a result in C2?

-200 100 ?
-150 100 ?
-100 100 ?
-50 100 ?
0 100 ?
50 100 ?
100 100 ?
150 100 ?
200 100 ?


--ron
 
M

mikerickson

=A2-IF(A2<0,-B2,B2) or
=IF(A2<0,A2+B2,A2-B2)

Pat;501133 said:
I am having trouble with a subtraction formula, Hoping someone can
help.
A2 is -200
B2 is 100
C2 needs the formula
What I have is =A2-B2*sign(A2) which works until A2 is 0, then it
doesn't
subtract the cells, C2 becomes 0
Can anyone help with this formula.
Thanks
Click to expand...
 
B

bj

maybe
=if(A1=0,-B1,(Abs(A1)-B1)*sign(A1))
or using your equation
=if(A1=0,-B1,A1-B1*sign(A1))
 
Top