|
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
Hi
see your other post -----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 How do? Excel version xp/2003 Mike Excuse my english . |
| All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com