debit

  1. J

    Returning a blank instead of zero in VLookup

    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)
  2. M

    Automatically populate cellls when date reached

    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...
  3. E

    How to perform a running total in Excel vba.

    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...
  4. M

    If F2 is -, then move that number to G2

    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...
  5. V

    How do you dynamically sum up a column and print sum to text?

    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...
  6. K

    Debits and Credits to offset in a column

    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...
  7. S

    Identify credits and debits within a week of each other

    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...
  8. J

    IF/OR Dilemma

    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)...
  9. C

    Need help with other side of the Journal Entry in one Column

    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...
  10. S

    credit debit account calculation in a dynamic sheet

    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...
  11. A

    Debit Credit generate list if equal to zero

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top