Hi,
Can someone please help with a single VBA syntax to calculate the average of some generated numbers?
Thank you.
Printable View
Hi,
Can someone please help with a single VBA syntax to calculate the average of some generated numbers?
Thank you.
Its fairly simple just create a var to hold your total.
Add all the numbers together
Divide by the number of numbers used.
Code:T=x+y+z
A=T/3
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 .
Look up:
Code:Eval()