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 [email protected]

Thanks in advance!