debit

I have the following formula and keep getting a zero when I want a blank returned. Please help! =IF(AND($D$102>0,$D$36="Direct Debit"),"Direct Debit Acct" &" "&$D$102,$D$36)

Hi, is there a way to automatically update a sheet when a date has been reached. This would be in a money file tracking bank accounts. so if I have a debit going out on the 1st of every month is there a way to automatically populate the next available row with the required data when the date has...

I have a sheet with four columns i.e Credit,Debit and Balance.I want VBA help for running total in the colum of Balance Credit Debit Balance 3 0 3 8...

I have bank statements that have some withdrawals (column G) in the deposit column (F). See example below. Can you PLEASE help me get these -$ figures into column G?! THANK YOU!!! <colgroup><col><col><col><col><col><col span="3"></colgroup><tbody> Post Date Transaction Description Account...

I have a work assignment to convert an excel file to text with specific number of spaces between each column because our older system does accept a direct import from excel. I have a column for gl codes and a column for amounts. here is what macro needs to print to text. if the "amount" is...

Hi, I have a large data that I exported in excel that include debit and credit in a column. I would like to find an easier way to pair the debit and credit to offset each other by a formula and easily find the variance. So the column would look something like this. Column A 250 400 350 -250...

Hi, I have a worksheet with multiple bank statement all combined together and sorted by date. Column E has the date, Column H has Debits and Column I has Credits, Row 1 has headers. I am trying to find a way of identifying debits and credits within a week of each other where the amount is the...

Hi everyone, I'm relatively new to formula chat so please bear with me, I'm trying to create a report that separates amounts if failing/succeeding on a system, Simply put, if there is data in a certain column (J) I have column (L) turn red and say the word "Fail" if no data is in column (J)...

I am trying to create a journal entry referencing back to another worksheet. What I have done so far is brought over the orginal $'s and created an if statement saying if a credit then equals 40 if debit equals 50. Now I am going back and trying to create the other side of the transaction buy...

hello frnds i am new to excel n i m using office 2010 plz can u help me in creating a debit credit sheet with dynamic functions step up step, cause i only know to fill the data in the sheets and nothing else. i have details of columns as follows with every column having a label A...

From my previous posts, I am trying to count the number of unique invoice numbers. However, if the invoice number has debits and credits I have to go through and match the debits and the credits. If the total amount is zero, the invoice number cannot be included in the original count. An...