One cell minus another

Welocme to the board.

when i type in g7 - h7 (g7 being a positive number and h7 being 0. I am getting a negative total.

Not if h7 is 0.

it would be like subtracting 0-200 - you would still get 200.

0 minus 200 is -200, not 200.

Agree with shg, 0-200 is -200 not 200

0-200=-200
200-0=200
ABS(0-200)=200
ABS(200-0)=200

Perhaps you are looking for the ABS() Absolute Value function?

http://austinist.com/2013/04/12/texa...ve_algebra.php

Reckon arithmetic is next.

Some of this just isn't making sense. You say that you want to find the difference between two cells (cell1-cell2), then, when that subtraction is performed, you are unhappy with the result. I'm not understanding (and I would guess that the others are not as well) exactly what you want.
allotted -- spent -- difference
100 -- 150 -- =150-100 -> +50 positive result indicates that spent was greater than allotted
150 -- 100 -- =100-150 -> -50 negative result indicates allotted was greater than spent
100 -- 0 (transaction pending) -- 0-100 -> -100 negative result indicates that transaction has not yet occurred (so is correctly showing that allotted is greater than spent because nothing has been spent, yet).

Is that the kind of thing you are looking at? What is wrong with the negative result in the final example? What would you like it to show instead of the "natural" difference of -100? (Perhaps what you are really looking for is an IF() function that will test for "transaction pending" and not compute the difference?)