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
Please don't ask every few minutes and pls don't ask in more than one ng.
-- Don Guillett SalesAid Software "Mike Perchoir" wrote in 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
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 | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |