View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Need help with a formula

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