text formulas
- From: Rus <Rus@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Jul 2005 07:06:07 -0700
I have "Y,N,&NA" in one column. In another column off to the right I am
counting those inputs. A total is then calculating those Y(which formulate
to be 100%) and N (which formulate to be 0%) and then averaging them.
However, I don't want the NA to be part of the average. Meaning, if NA is
input, then the count would be NA, instead of 0% (like the N). It throws off
the average and I want it excluded from the avg calculation
Any thoughts on how to get this to work??
.
- Follow-Ups:
- Re: text formulas
- From: Tim C
- Re: text formulas
- From: Mangus Pyke
- Re: text formulas
- Prev by Date: Can I create a dropdown that will show a 2-month calendar?
- Next by Date: Re: Array Function
- Previous by thread: Can I create a dropdown that will show a 2-month calendar?
- Next by thread: Re: text formulas
- Index(es):
Relevant Pages
|
Loading
