G
giannchr
Nos Jun/2004 %Increase AmountIncr. Dec/2004
------------------------------------------------
1 9258 17,00 1573,86 10831,86
2 9000 ? ? ?
3 8720 ? ? ?
4 8100 ? ? ?
5 7245 ? ? ?
6 6500 30,00 1950,00 8450,00
------------------------------------------------
Total 48823 average20% 9764,60 58587,60
================================================
the average increase must be 20%
The amount increase must be 9764,60
The high balance of June'04 must have lower increase
The Low balance of June'04 must have hig increase
The lowest %increase must be 17%
The highest %increase must be 30%
WHAT FORMULA MUST I USE ??
I PRECIATE IF YOU SEND ME AN E-MAIL WITH THE SPREAD SHEET
(e-mail address removed)
many thanks to all of you !!!
------------------------------------------------
1 9258 17,00 1573,86 10831,86
2 9000 ? ? ?
3 8720 ? ? ?
4 8100 ? ? ?
5 7245 ? ? ?
6 6500 30,00 1950,00 8450,00
------------------------------------------------
Total 48823 average20% 9764,60 58587,60
================================================
the average increase must be 20%
The amount increase must be 9764,60
The high balance of June'04 must have lower increase
The Low balance of June'04 must have hig increase
The lowest %increase must be 17%
The highest %increase must be 30%
WHAT FORMULA MUST I USE ??
I PRECIATE IF YOU SEND ME AN E-MAIL WITH THE SPREAD SHEET
(e-mail address removed)
many thanks to all of you !!!