EXcel IF function

J

jamie

Hi All,

I want to construct a formula that helps me work out an outstanding
balance...

Each customer gets a row.

They get a price (say £1000) that is split into three payments,
Deposit, Interim and Balance (worked out by formula =sum(£1000/4) etc.

What I want to do is as follows:

When the customer has paid the deposit, I want to put a 'Y' in the
column next to the Deposit column. Upon putting the 'Y' in, the
deposit will be deducted from the price and shown in a column called
'Remaining'...

Does this make sense...

Price Deposit Paid Interim Paid Balance Paide...
Remaining

1000 250 Y 500 Y 250
N 250

Can anyone help! Thanks in advance
 
D

Don Guillett Excel MVP

Hi All,

I want to construct a formula that helps me work out an outstanding
balance...

Each customer gets a row.

They get a price (say £1000) that is split into three payments,
Deposit, Interim and Balance (worked out by formula =sum(£1000/4) etc..

What I want to do is as follows:

When the customer has paid the deposit, I want to put a 'Y' in the
column next to the Deposit column. Upon putting the 'Y' in, the
deposit will be deducted from the price and shown in a column called
'Remaining'...

Does this make sense...

Price    Deposit    Paid    Interim     Paid    Balance     Paide...
Remaining

1000    250          Y        500          Y        250
N           250

Can anyone help! Thanks in advance

if(c1="y",a1=b1,a1)
or
a1-(if(c1="y",b1,0)
 

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