IF Formula Help

[FrustratedInWV]

I'm working on a spreadsheet. What I need to do is show a profit or loss - if we pay someone x amount of money up front, then we get the actual amount at a later date, and the amount of the actual is 0, then I need to show a credit of the money paid out which will be credited toward future transactions. The numbers in both columns will be variable. For example, if Column A is 152.00 and column B is 0 then how do I get it to show -152.00 without having to change it every time. I hope this is not confusing.

 

[kweaver]

So, J2 is =H2-F2 ?

Left to right; right to left. It's the (arbitrary and illogical) order of operations that often throws everyone.
Why should multiplication and division come before add and subtract? Beats me. Then, why should a tie with either pair be "left to right" when a tie in exponents is "right to left" (2^3^4 is 2^81, etc.)?
Totally illogical. Oh, BTW, there are ALL functions and yet f(g(x)) is right to left (i.e., have to do g(x) first -- which is the right-most function). It should ALL be right to left!!! No wonder kids hate math.

 

[FrustratedInWV]

It can get confusing especially the "new" math they are teaching children. I guess I'm just too old lol.

Thank you again so much for your help. I do appreciate it more than you can know.