vba function
 

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

How do?
Excel version xp/2003

Mike
Excuse my english

vba function
 

I've no idea what an "indice" is, nor is it in my help files. But the results you're after could just be cell formulas, no need to use VB. Just put your data on one sheet and the formulas with headings on another

----- Mike Perchoir wrote: ----

Hell

i've the following dat
Année V1 V2 V3 Nationa
1992 14805 10
1993 16521 2640 12
1994 17839 2142 11
1995 19878 1236 1207 13
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 V
V3 Nationa
1992 (14805 *100)/1480
10
1993 (16521*100)/1480
(2640*120)/2640 12
1994 17839 *100)/14805 (2142*117)/214
11
1995 19878 *100)/14805 (1236*117)/214
(1207*120)/2640 13
1996 12456 *100)/14805 (1024 *117)/214
14
1997 14526 *100)/14805 (1563 *117)/214
(1274*120)/2640 15

How do
Excel version xp/200

Mik
Excuse my englis