Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |