Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba or formula help?
Hello
I have 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 I want to calculate an "'indice" with vba or a formula example: to obtain these news values Année V1 1992 (14805 *100)/14805 1993 (16521*100)/14805 1994 17839 *100)/14805 1995 19878 *100)/14805 1996 12456 *100)/14805 1997 14526 *100)/14805 Année V2 V3 National 1992 100 1993 (2640*120)/2640 120 1994 (2142*117)/2142 117 1995 (1236*117)/2142 (1207*120)/2640 136 1996 (1024 *117)/2142 140 1997 (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 or formula help?
Hi Mike;
I am writing asuming that V1, V2 & V3 are in seperate columns A, B & C. I am also asuming the activecell is in column D. On way to do it in VBA is Activecell = Activecell.Offset(0,-3)*100/Activecell.Offset (0,-2) I hope that helps -----Original Message----- Hello I have 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 I want to calculate an "'indice" with vba or a formula example: to obtain these news values Année V1 1992 (14805 *100)/14805 1993 (16521*100)/14805 1994 17839 *100)/14805 1995 19878 *100)/14805 1996 12456 *100)/14805 1997 14526 *100)/14805 Année V2 V3 National 1992 100 1993 (2640*120)/2640 120 1994 (2142*117)/2142 117 1995 (1236*117)/2142 (1207*120)/2640 136 1996 (1024 *117)/2142 140 1997 (1563 *117)/2142 (1274*120)/2640 152 How do? Excel version xp/2003 Mike Excuse my english . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba or formula help?
Again? What is the matter?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mike Perchoir" wrote in message ... Hello I have 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 I want to calculate an "'indice" with vba or a formula example: to obtain these news values Année V1 1992 (14805 *100)/14805 1993 (16521*100)/14805 1994 17839 *100)/14805 1995 19878 *100)/14805 1996 12456 *100)/14805 1997 14526 *100)/14805 Année V2 V3 National 1992 100 1993 (2640*120)/2640 120 1994 (2142*117)/2142 117 1995 (1236*117)/2142 (1207*120)/2640 136 1996 (1024 *117)/2142 140 1997 (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 | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |