if equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to come up with a formula that will subtract if the value in one
cell is negative or will add if the value in the same cell is positive
 
add or subtract what? Please be detailed with your questions, otherwise we
are stabbing at the dark. These examples might help you. If not, then
please provide the input data you have and the outcome you want.

Example 1:
A1 12
A2 -4
A3 =A1+A2
this will subtract A2 from A1 resulting in 8

Example 2:
A1 12
A2 3
A3 -67
A4 =A1+A2*A3/ABS(A3)
this will subtract A2 from A1 resulting 9
 
Robert said:
i am trying to come up with a formula that will subtract if the value in
one
cell is negative or will add if the value in the same cell is positive

A1=2; A2=3
A3=A1+A2*SIGN(A2)
Now put a negative in A2.

kjs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top