Balancing check book formulas

[John Jordan]

I am trying to create a spreadsheet that balances my clubs books. Debits are in G6, Credits are in I6 and balance is in K6. I am looking for a formula that leaves K6 blank if there are no numbers in G6 or I6; and will subtract any amounts in G6 and add any amounts in I6. Hope this if sufficient information and thanks for any assistance.

 

[mumps]

Something like this adjusting the row references: =IF(AND(G4="",I4=""),"",K3-G4+I4)

 

[Marcílio_Lobão]

John Jordan, Good morning.

Try to use:

K6 --> =IF((G6+I6)=0, "", K5-G6+I6)

Is that what you want?
I hope it helps.

Have a nice day!

 

[John Jordan]

Thank you so much, it works great!
John..

John Jordan, Good morning.

Try to use:

K6 --> =IF((G6+I6)=0, "", K5-G6+I6)

Is that what you want?
I hope it helps.

Have a nice day!

 

[John Jordan]

Thanks for your help. Works great.
John..

Something like this adjusting the row references: =IF(AND(G4="",I4=""),"",K3-G4+I4)

 

[Marcílio_Lobão]

John Jordan, Good morning.

Thanks for the comments.

I'm glad to have helped.

 

[mumps]

Glad it worked out.