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