-
July 28th, 2009, 02:34 AM
#1
Code for Average in VBA
Hi,
Can someone please help with a single VBA syntax to calculate the average of some generated numbers?
Thank you.
-
July 28th, 2009, 03:07 AM
#2
Re: Code for Average in VBA
Its fairly simple just create a var to hold your total.
Add all the numbers together
Divide by the number of numbers used.
-
July 28th, 2009, 04:12 AM
#3
Re: Code for Average in VBA
Save the numbers generated to different variables. Then add all the values together and then divide it by the number of variables used. That will give you the solution .
-
July 28th, 2009, 10:08 PM
#4
Re: Code for Average in VBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|