Help! Quick question on summing series

[killadrilla]

Basically, I need to write a VBA function which evaluates the function "1/i" for values from i = 1 to n. n can be any integer larger than one. It then adds all those terms to get the final answer. For example, if n = 4, the sum would be (1/1) + (1/2) + (1/3) + (1/4) = 2.083

I can make the formula which evaluates 1/n, but not sure how to add the series starting at 1. I am referencing n from a value on the spreadsheet, and then pasting the final answer back onto the sheet.


So far here is what I have:

Please Login or Register  to view this content.

[arthurbr]

Hi and welcome to the board, unfortunately

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[killadrilla]

thank you for letting me know, it's been fixed

[DonkeyOte]

You might need to retitle your thread (specifically remove "Help") but do you really need a UDF ?

One formula based approach:

=SUMPRODUCT(1/ROW(A$1:INDEX(A:A,$A$1)))

where A1 holds n

There are plenty of others.

[killadrilla]

Thanks, but is there a method that only uses VBA?

You might need to retitle your thread (specifically remove "Help") but do you really need a UDF ?

One formula based approach:

=SUMPRODUCT(1/ROW(A$1:INDEX(A:A,$A$1)))

where A1 holds n

There are plenty of others.

[DonkeyOte]

Please Login or Register  to view this content.

but it will be slower...

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.