473,503 Members | 1,706 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sum of product vba

14 New Member
Can someone give some hints???
Id like to know if someone have a code for visual basic/ excel to calculate the SUM OF the product of a sequence of numbers in VBA, i'm using windowns 7/vista. In other words
I want to calculate the value of

of


The definition of the product of n numbers is https://es.wikipedia.org/wiki/Productorio
x = 10 -1/n is the number generating function for j from 0 to n
Product function in VBA of all the numbers that are generated from that equation (x = 10 -1/n) is given by:
Function mo(J, n) As Double

Dim i As Integer
Dim x As Double

mo = (x^2)*y
For i = 2 To n
x = 10 - (1 / i)
y= 10 - (1 /( i-1))

mo = mo * (x^2)*y
Next i

mo = mo / ((x^2)*y)

End Function

I want the sum of [product (x^2)*y]*1/100 from i = 2 To n
Can someone tell me please how to calculate the sum above in vba/excel? in other words how do i calculate the sum of the(Function mo (x^2)*y])/100 described above from i = 2 To n ???
many thks in advance
Sep 11 '17 #1
0 1616

Sign in to post your reply or Sign up for a free account.

Similar topics

2
7037
by: Thomas P. Fuller | last post by:
Hi, thanks in advance for any help you can offer me. I'm wrestling with the following problem: The following is on the same jsp page and say that the product parameter is "foo": // This...
2
2063
by: yackel | last post by:
Hi there, I'm just in the paper-designing stage of an inventory / sales database but am looking for some help and suggestions as it seems a little out of the norm due to the different classes of...
1
3342
by: urban.john | last post by:
Here are my steps: create resource files from resx files: <echo message="CREATING RESOURCE FILES FROM RESGEN EN" /> <resgen todir="product\resources_en" verbose="true"> <resources> <include...
1
2150
by: ollielaroo | last post by:
Hi guys, Firstly I did do a search for this one first but I couldn't find anything related in this forum. I am using Dreamweaver MX and trying to build admin pages for an ASP site. My problem is...
0
1578
by: fiona | last post by:
Yucca Valley, CA, - November 2007: Catalyst Development Corporation, publisher of SocketTools, SocketWrench and LogicGem, today unveiled their new corporate website and Product Wizard Tool. The...
0
2074
by: David Troxell - Encourager Software | last post by:
Product Scope 7 (http://www.encouragersoftware.com/) and Profile Exchanges enhanced with SetupCast publishing methods NOTE: If you are a software author, releasing commercial and/or shareware...
4
1721
by: atanu | last post by:
Hi! I am Atanu. I am working in a company dealing with manufacturing of mechanical spear parts. When we release a product for manufacturing we make drawing and given the same to the factory. To make...
2
14417
PsychoCoder
by: PsychoCoder | last post by:
NOTE: Posted this on my blog this morning but also felt the bytes community could benefit from it. I've seen this question asked many times on different forums and thought I'd develop a solution...
0
7201
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7083
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
6988
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7456
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3153
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1510
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
734
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
379
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.