formula needed for monthly statement. Thank you

[jojo4santa]

Thank you so much genius super coders: MarvinP, wk9128, TMS for your time & super quick help as allways. God bless you all.
I add all stars to your reps if allowed
Request is now SOLVED !!

*******************

Hi Super coders

Wishing you a great week.
Attached is the expenses.
I need the formula that shows on the new balance:
The New balance would be = the previous balance minus the credit if any or plus the debit if any.
Thanks a lot for your time & help

[MarvinP]

Hi jojo,

See if the attached helps..

[wk9128]

CELL G5 formula , Drag down

Please Login or Register  to view this content.

[TMS]

G5, copied down:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep.


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[wk9128]

@jojo4santa You're Welcome. Glad to help . Thank You for the feedback and rep.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.