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