Thread: How do I subtract a negative number from a positive number?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I subtract a negative number from a positive number?
Hi,

H3 = -6
I3 = 6

Your formula
=I3-H3
Gives me 12. What do you get? What do you expect to get?

Mike


"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.
Reply With QuoteReply With Quote