How do i compute the average value of 100 iterations?

[il_102]

I need to compute the avg of all 100 iteraions. I set the iterations in the
Tool->options->calculation->iteration. Now i need to compute the avg of all
100 iterations. Any help would be greatly appreciatted.
Thanks,
Il

[Bernie Deitrick]

Il,

You would need to use VBA to do the actual calc....

HTH,
Bernie
MS Excel MVP


"il_102" <il_102@discussions.microsoft.com> wrote in message
news:87CE7217-48B9-471C-9154-754004544A3C@microsoft.com...
>I need to compute the avg of all 100 iteraions. I set the iterations in the
> Tool->options->calculation->iteration. Now i need to compute the avg of all
> 100 iterations. Any help would be greatly appreciatted.
> Thanks,
> Il

[il_102]

Is there an example of something that i can use to do this?
thanks

"Bernie Deitrick" wrote:

> Il,
>
> You would need to use VBA to do the actual calc....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "il_102" <il_102@discussions.microsoft.com> wrote in message
> news:87CE7217-48B9-471C-9154-754004544A3C@microsoft.com...
> >I need to compute the avg of all 100 iteraions. I set the iterations in the
> > Tool->options->calculation->iteration. Now i need to compute the avg of all
> > 100 iterations. Any help would be greatly appreciatted.
> > Thanks,
> > Il
>
>
>

[Bernie Deitrick]

Try something like the sub below, for a formula in cell A1.

HTH,
Bernie
MS Excel MVP

Sub Macro1()
Dim i As Integer
Dim mySum As Double

With Application
.Iteration = True
.MaxIterations = 1
End With

For i = 1 To 100
Range("A1").Calculate
mySum = mySum + Range("A1").Value
Next i

MsgBox "The average is " & mySum / 100

With Application
.Iteration = False
End With

End Sub

"il_102" <il102@discussions.microsoft.com> wrote in message
news:7E989CE9-D41F-4081-80D6-40ED0DC68E68@microsoft.com...
> Is there an example of something that i can use to do this?
> thanks
>
> "Bernie Deitrick" wrote:
>
>> Il,
>>
>> You would need to use VBA to do the actual calc....
>>
>> HTH,
>> Bernie
>> MS Excel MVP
>>
>>
>> "il_102" <il_102@discussions.microsoft.com> wrote in message
>> news:87CE7217-48B9-471C-9154-754004544A3C@microsoft.com...
>> >I need to compute the avg of all 100 iteraions. I set the iterations in
>> >the
>> > Tool->options->calculation->iteration. Now i need to compute the avg
>> > of all
>> > 100 iterations. Any help would be greatly appreciatted.
>> > Thanks,
>> > Il
>>
>>
>>

[il_102]

Thank you very much!!! it helped a lot

"Bernie Deitrick" wrote:

> Try something like the sub below, for a formula in cell A1.
>
> HTH,
> Bernie
> MS Excel MVP
>
> Sub Macro1()
> Dim i As Integer
> Dim mySum As Double
>
> With Application
> .Iteration = True
> .MaxIterations = 1
> End With
>
> For i = 1 To 100
> Range("A1").Calculate
> mySum = mySum + Range("A1").Value
> Next i
>
> MsgBox "The average is " & mySum / 100
>
> With Application
> .Iteration = False
> End With
>
> End Sub
>
> "il_102" <il102@discussions.microsoft.com> wrote in message
> news:7E989CE9-D41F-4081-80D6-40ED0DC68E68@microsoft.com...
> > Is there an example of something that i can use to do this?
> > thanks
> >
> > "Bernie Deitrick" wrote:
> >
> >> Il,
> >>
> >> You would need to use VBA to do the actual calc....
> >>
> >> HTH,
> >> Bernie
> >> MS Excel MVP
> >>
> >>
> >> "il_102" <il_102@discussions.microsoft.com> wrote in message
> >> news:87CE7217-48B9-471C-9154-754004544A3C@microsoft.com...
> >> >I need to compute the avg of all 100 iteraions. I set the iterations in
> >> >the
> >> > Tool->options->calculation->iteration. Now i need to compute the avg
> >> > of all
> >> > 100 iterations. Any help would be greatly appreciatted.
> >> > Thanks,
> >> > Il
> >>
> >>
> >>
>
>
>