Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code help - first timer
Hello all, I am trying to write a UDF for Excel, and I haven't worked with VB programming before. Here is what I want to do: Two columns next to each other (for example, a and b, but no necessarily those exact columns). Column A is filled wit "distribution" amounts, are long decimal numbers (ie .0084840). Colum B is filled with matching dollar amounts (ie 10.75). So, cells A1 an B1 are a "record" or match, A2 and B2, all the way down to An and Bn ( being any number). What I want to do is take the distribution amounts divide it by the dollar amount (ie A1/B1), add one to the fraction then multiply all records together. In other words: (1+(A1/B1))*(1+(A2/B2))*(1+(A3/B3))*.........*(1+(An/Bn)). Any help? post back here or email me at Thanks in advance -- Poot ----------------------------------------------------------------------- Poots's Profile: http://www.excelforum.com/member.php...fo&userid=2415 View this thread: http://www.excelforum.com/showthread.php?threadid=37780 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code help - first timer
Not NECESSARY to use a UDF - this formula will do the job. If your data is
A1:B13, ctrl/shift/enter this: =PRODUCT((1+A1:A13/B1:B13)) Bob Umlas Excel MVP "Poots" wrote in message ... Hello all, I am trying to write a UDF for Excel, and I haven't worked with VBA programming before. Here is what I want to do: Two columns next to each other (for example, a and b, but not necessarily those exact columns). Column A is filled with "distribution" amounts, are long decimal numbers (ie .0084840). Column B is filled with matching dollar amounts (ie 10.75). So, cells A1 and B1 are a "record" or match, A2 and B2, all the way down to An and Bn (n being any number). What I want to do is take the distribution amounts, divide it by the dollar amount (ie A1/B1), add one to the fraction, then multiply all records together. In other words: (1+(A1/B1))*(1+(A2/B2))*(1+(A3/B3))*.........*(1+(An/Bn)). Any help? post back here or email me at Thanks in advance! -- Poots ------------------------------------------------------------------------ Poots's Profile: http://www.excelforum.com/member.php...o&userid=24154 View this thread: http://www.excelforum.com/showthread...hreadid=377806 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code help - first timer
=SUMPRODUCT(1+A1:A10/B1:B10)
-- Regards, Tom Ogilvy "Poots" wrote in message ... Hello all, I am trying to write a UDF for Excel, and I haven't worked with VBA programming before. Here is what I want to do: Two columns next to each other (for example, a and b, but not necessarily those exact columns). Column A is filled with "distribution" amounts, are long decimal numbers (ie .0084840). Column B is filled with matching dollar amounts (ie 10.75). So, cells A1 and B1 are a "record" or match, A2 and B2, all the way down to An and Bn (n being any number). What I want to do is take the distribution amounts, divide it by the dollar amount (ie A1/B1), add one to the fraction, then multiply all records together. In other words: (1+(A1/B1))*(1+(A2/B2))*(1+(A3/B3))*.........*(1+(An/Bn)). Any help? post back here or email me at Thanks in advance! -- Poots ------------------------------------------------------------------------ Poots's Profile: http://www.excelforum.com/member.php...o&userid=24154 View this thread: http://www.excelforum.com/showthread...hreadid=377806 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TIMER | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Timer | Excel Programming | |||
How to code a timer to trigger a sub-routine ? | Excel Programming | |||
Timer | Excel Programming |