Combining Formulas

[truevidence]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Contract#[/TD]
[TD]Contract amount[/TD]
[TD]Already encumbered[/TD]
[TD]Invoices Paid[/TD]
[TD]Already Encumbered Balance[/TD]
[TD]Current Contract Amount[/TD]
[TD]Encumbered[/TD]
[TD]Unencumbered[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1234[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]40[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I made a small copy of my spreadsheet. I will try to explain what I want to do to the best of my ability.

I want to get an accurate balance that's left on the contract. When I encumber funds I want to subtract G2 from F2 with the amount showing in I2. When I want to unencumber funds I want to add C2 and H2 with that total showing in I2 as well. However I don't want both totals showing at the same time. I want them to show when I enter a number in either G2 or H2. There won't be anything in both cells at the same time, G2 will always be a positive number, and H2 will always be a negative number. Can anyone help me?

 

[mrshl9898]

=if(g2<>"",f2-g2,if(h2<>"",c2+h2,))

 

[dreid1011]

Welcome to the board.

Perhaps something like this:

=IF(G2<>"",F2-G2,IF(H2<>"",C2+H2,""))

 

[truevidence]

Thank you for the help and the kind welcome! It worked I totally appreciate this!

 

[dreid1011]

Thank you for the help and the kind welcome! It worked I totally appreciate this!

You're welcome.