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.
|