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
HI
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
Ok
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
Okay
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.