IF(I2-I25,"yes",K3=K2-C3:F3) formula not working, why?


G

Guest

I need to keep a bank balance with a current balance (column H) and a running
balance (column K) for those posted on bank statement. If posted, cell
(column I) is 'yes' if not 'no'.
 
Ad

Advertisements

B

Bob Phillips

Bit unclear, but her is a shot

=IF(I2="Yes",K2-SUM(C3:F3),"")



HTH



RP
(remove nothere from the email address if mailing direct)
 
G

Guest

Hi Bob - Thats was a great help but perhaps this will be clearer for you:

A B C D E F G H
I
1 Desc Cheque + DD SO Cash Receipt Bal Pesented Avail Bal
2 Opening Balance 1500 1500 yes
1500
3 subsistance 40 1460 no
4 electric 20 1440 yes
1480
5 Cheque 500 1940 Yes 1980

I need a formula that calculates outgoings (B-E) and also receipts (F) but I
also need it to recognise the “yes†when it appear on the “Presented†and to
calculate “Available Balance†– total here is 1980. But when the "no" is
changed to "yes" I also need it to calculate this! Is there a formula that
can do this?? Or am I expecting too much!!

Thanks Chieron
 
B

Bob Phillips

That has come out a bit garbled. Can you re-do it with pipes,like

Desc || Cheque+||DD||-||-|| 1 || 2 ||

etc

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Ad

Advertisements

G

Guest

Hi Bob - Hope this is better:

A B C D E F G H
I
Desc ||Cheque +||DD||SO||Cash||Receipt||Bal
||Pesented||Avail Bal
Opening Balance|| || || || ||1500 ||1500||
yes ||1500
Subsistance || || || || 40 || ||1460||
no || Eectric || || || 20|| ||
||1440|| yes ||1480
Cheque || || || || ||500 ||1940||
yes ||1980

I need a formula that calculates outgoings (B-E) and also receipts (F) but
I also need it to recognise the "yes" when it appear on the "Presented" and
to calculate "Available Balance" - total here is 1980. But when the "no" is
changed to "yes" I also need it to calculate this! Is there a formula that
can do this?? Or am I expecting too much!!

Thanks Chieron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top