YouTubersLoveExcel#17: Hide Bank Rec Formula

I am working on a spread sheet that is being used as an order form. I have it set so that the user would enter a quantity and the total would be displayed per item, as well as a grand total at the bottom of the sheet. I want the cells with a 0 value to be blank, and right now they are displaying a 0. Help I have seen similar threads, but I am assuming that the simple solutions do not work for me since I am working on Excel 2008 for Mac, version 12.2.7

Hi,


Is there a formula for an account balance sheet the same as a normal bank statement?, I thought it would be something staight forward but i'm having trouble finding the answers in the forums...

eg.

column A is DATE, column B is DEBIT, column C is CREDIT, column D is BALANCE

And all you do is input the debits and credits and the balance progressively calculates in column D.

Is this possible?

Thank You and sorry if the question is ridiculously simple.

Hi

I can download statements from my bank (HSBC, for future Googlers) in the following format. Does anyone know what formula I can use to show a running balance in column D (i.e. to the right of 'amount')?
I've tried various things and the only way I've had success is to filter the credits and debits into seperate columns due to the way the formula interprets the '-' symbols...

Thank you!
date description amount 01.12.2011 supermarket -10 02.12.2012 wages 1000 04.12.2011 butcher -5 06.12.2011 child benefit 80

Hi folks, wonder if someone could help me with this one. i have two worksheets, one is the bank statements the other is my own record of cheques paid out etc.

basically what i want to do is get a cheque number from the statements look and find that cheque number in the cheques paid tab and return a value to a cell in the statement tab.

Hi
I have searched forums but to no avail at the moment.
I am trying to have a formula that will show the date for a mailing to be sent out. Normally the day in is day out unless it is a Saturday or Sunday when it will be Monday. So far so good. Problem is if the day is a bank holiday eg Good Friday. My formula still sends out the same day. I need it to go to the Tuesday, ie day after Easter Mondya. Formula is as follows - "holidays" is the array with holiday dates in. thank you in advance

Dave

=IF(ISBLANK(E200),"",IF(WEEKDAY(E200,2)<6,E200,WORKDAY(E200,1,holidays)))

E200 is date received.

Hello everyone,

Is it possible to write an IF statement that determines whether a date is a bank holiday or not?

Thanks, Kenny.

Hi. I have a workbook where i have created a programme which contains a dataset of images in different colours and a macro which transfers the images onto another worksheet depending on the colours chosen by the user.
I have now protected the worksheets ( only the cells which contains the images), but when I hit the macro button to create image it doesnt transfer the images anymore?

any ideas?

thanks

Hi

I'm sure someone can help easily with this.

I have a spreadsheet in which a target date is calculated, plus the number of days it takes to meet that date and the day number I am on. At the moment I manually take off days to take into account bank holdiays and fiddle around with the sheet as and when I need to, but I understand this can be done for me.

My target date is my first date plus 20. ie =WORKDAY(C5,20)

The actual day number I am on when I check my sheet each day is
number of days taken is calculated by
=NETWORKDAYS(P5,TODAY()) - I then insert minus the bank hols each time I need to.

The number of days to reach the target is calculated by
=NETWORKDAYS(P5,F5) (again doing the number of bank holidays each time)

Any ideas how to insert a reference to deduct any standard bank holidays which I understand are inbuilt. I have Analaysis Toolpak installed already to get the dates, days I get already

Any ideas?

cheers

HI All,
I need some help regarding Bank Reconcilation.
Our's is a AP process. When we try to reconcila Account's at the end of month it takes lot of time to Reconcila.

I like to know Whether there is a procedure,module or formula in excel which Can help our's to Reconcila much easier and also save time.

Regards,
Manju

Hello , i have recently moved to a new bank and they use Excel instead of Access , with which i was familiar.So , maybe you can help me solve a problem.here it is :
i have a huge table with alphabetical ordered clients.since there are two persons who manage the clients , each client has a code, let's say some have 1 and some have 0, so two columns : one with the name and one with a code for every client. Secondly , i have a table with the clients processed in the last month , they all are found in the first table and i have to make a function that selects only the clients which have code 1 in table 1 . Assuming i can copy&paste the column in the second table into the first one , thus making it 3 columns in the first , can you tell me what function must i use to make such filtering ? thank you