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

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)

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