Formula help

[SSKT16]

How do i write a formula for the following:

G4=g3-e4 or g3+f4

thank you for any and all help!

 

[Special-K99]

You havent said under what circumstances G4

should = g3+f4 ?
Or g3-e4 for that matter.

 

[Gerald Higgins]

Well one way is to just input into cell G4 the following

=G3-E4

But your request is a bit vague - can you explain the "or" bit in more detail please ?

 

[SSKT16]

Sorry, so column G is a "running total" Column E would be a debit and column F would be a credit - I need column G to either add column F or subtract column E to the previous balance.

 

[dazfoz]

Would the following not work, assuming that you debit is a +ive and your credit is a -ive?

=G3+F3+E3