Skip to Content
0
Former Member
Apr 19, 2008 at 06:55 AM

Calculated characteristics- How to write formula?

592 Views

Hi All,

Can any one help me in maintaining a formula for calculated MIC.

I am having inspection characteristics 0010,0020, 0030, 0040,0050. But during result recording I will not record for all characteristics, I may do it only for 3 or 4 chars randomly.

Now my calculation requirement is to capture mean value of above recorded results.

Char 0060 = Mean Value of only Recorded results from 0010, 0020, 0030,0040, 0050

I cannot write formula like char 0060= (C00010+ C00020+ C0030+ C00040)/5 because some times I may record only 2 values and some time I record 3 values randomly. Number of recording may vary from time to time.

That is why I am looking for Mean Value of only Recorded results between 0010 and 0050.

Could anyone please help me regarding at the earliest time.

If possible by standard formula, please mention formula also while replying.

With Kindest regards,

Vineeth