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 |
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 |