Re: help in excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You will need to elaborate on the question. Give details of how the data is
laid out in the work***, and exactly what you need.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jojo" <Jojo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B330BAB5-6BFA-469B-B45E-B9FDFF26D50F@xxxxxxxxxxxxxxxx
How do you create automatically subtract the balance each month. We use 13
periods for a year.

"Bernard Liengme" wrote:

A2 has client's name
B2:N2 has the monthly charges for first year
M2 has total yearly cost
So =M2-SUM(B2:N2) will give you the balance.
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jojo" <Jojo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4BCE9691-7C9E-45CB-83FE-C75320CEB89C@xxxxxxxxxxxxxxxx
Can anyone help me, please!
I have a work*** created as client contract agreement.
first column was the client name, start from second column is each
month
pricing (the columns is base on the lenght of the contract, it is
between
1
year to 3 years.), after the columns will the annual total price that
client
paid. But I want to create one column that it will automatically
subtract
each month pricing from the annual total price.

For your infor. we use 13 periods a year instead of 12 periods.







.

Quantcast