Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am producing a trial balance and have a credit and debit column, I also have a jnl credit and debit and a final TB credit and debit. Please can you give me the formula to add all the debits minus the credits and put the figure if above 0 in the final debit column if not leave blank.
Solved by B. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/04/2018 - 02:04
Hi there
User 05/04/2018 - 02:04
Excelchat Expert 05/04/2018 - 02:04
How are you and how may i assist you with today?
User 05/04/2018 - 02:05
Shall I put it on the blank sheet to show you what I need?
Excelchat Expert 05/04/2018 - 02:05
Yep sure
User 05/04/2018 - 02:06
I need to add the debits and minus the credit then if the value is above 0 put it in he final debit column.
User 05/04/2018 - 02:07
Alternatively if it is in the credit column it needs to add the credit minus the debit and put the figure in
Excelchat Expert 05/04/2018 - 02:07
Why E5 seems to be blank
Excelchat Expert 05/04/2018 - 02:09
see in E 15
User 05/04/2018 - 02:09
Ive just copied a few of my figures from my spreadsheet. I need it to be so that in H8 the figure is 0 and in I8 its 65800.39
User 05/04/2018 - 02:10
sorry H7
User 05/04/2018 - 02:11
Theres an If statement that will do it but I cant remember it and I moved work places so can't access a previous spreadsheet
Excelchat Expert 05/04/2018 - 02:12
yes but i should have the clear condition to get the if statement for you
Excelchat Expert 05/04/2018 - 02:12
so lets go step by step
User 05/04/2018 - 02:12
Excelchat Expert 05/04/2018 - 02:13
Anything to be refered from column B and c?
User 05/04/2018 - 02:13
They are the starting figures
User 05/04/2018 - 02:15
I need the totals to be in column H & I
Excelchat Expert 05/04/2018 - 02:15
Excelchat Expert 05/04/2018 - 02:16
just for my understanding i'm doing it roughly
Excelchat Expert 05/04/2018 - 02:16
will get the formula in I and H
Excelchat Expert 05/04/2018 - 02:19
so we need to do 67000-1200, right?
Excelchat Expert 05/04/2018 - 02:20
Are you there?
Excelchat Expert 05/04/2018 - 02:21
Can i get a reply?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc