View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default How do I subtract a negative number from a positive number?

Any time you subtract a negative, it is the same as adding a positive.
=I3-H3, assuming I3=7, and H3=-4
=7-(-4) or 7+4, which =11.
If you want the H column to show a negative value, you could use the formula
of
=I3+H3, or =7+(-4), =7-4, =3
If, however, you want H to have a value that is subtracted, i.e.: H3 is now
4, vice -4, then you could leave the formula as =I3-H3
--
John C


"csanta" wrote:

I need a formula to subtract a negative from a positive #.
Ex. I have =I3-H3 in the cell but H3 is negative and I3 is positive and it
is adding them instead of just displaying the difference.