vba function

[Guest]

Hell

i've the following data
Année V1 V2 V3 Nationa
1992 14805 10
1993 16521 2640 120
1994 17839 2142 117
1995 19878 1236 1207 136
1996 12456 1024 14
1997 14526 1563 1274 15

jI want to calculate an "'indice" with vba

example: to obtain these news value
Année V1 V2 V3 Nationa
1992 (14805 *100)/14805 10
1993 (16521*100)/14805 (2640*120)/2640 120
1994 17839 *100)/14805 (2142*117)/2142 117
1995 19878 *100)/14805 (1236*117)/2142 (1207*120)/2640 136
1996 12456 *100)/14805 (1024 *117)/2142 14
1997 14526 *100)/14805 (1563 *117)/2142 (1274*120)/2640 15

How do
Excel version xp/200

Mik
Excuse my english

 

[Frank Kabel]

Hi
first: please check your newsreader. you have posted this
question several times in different groups. This won't get
you any more answers

For your question: Some questions up-front:
- Do you want to overwrite the existing values with the
news ones or would it also be possible to use an adjacent
column for storing the results
- does it has to be VBA or would a formula also work for
you (would require an additional column)

-----Original Message-----
Hello
,
i've the following data
Année V1 V2 V3 National
1992

14805 100

1993 16521 2640 120
1994 17839

2142 117

1995 19878 1236 1207 136
1996 12456

1024 140

1997 14526 1563 1274 152

jI want to calculate an "'indice" with vba.

example: to obtain these news values
Année V1

V2 V3
National

1992 (14805

*100)/14805
100

1993

(16521*100)/14805
(2640*120)/2640 120

1994 17839 *100)/14805

(2142*117)/2142
117

1995 19878 *100)/14805

(1236*117)/2142 (1207*120)/2640 136

1996 12456 *100)/14805 (1024

*117)/2142 140

1997 14526 *100)/14805 (1563

*117)/2142 (1274*120)/2640 152