# Can anyone handle an argument

Posted by Patrick on May 09, 2001 7:04 AM

The first formula works however the second
has to many arguments

=IF(ISERROR(COUNTIF(B24:B47,"&LT;75")/C13),"0%",(COUNTIF(B24:B47,"&LT;75")/C13))

=IF(ISERROR(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90"))/C13),"0%",(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90"))/C13))

Thanks!!

Posted by Dave Hawley on May 09, 2001 7:14 AM

Hi Patrick

Try:

=IF(ISERROR(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90")/C13),"0%",(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90")/C13))

Dave

Posted by Patrick on May 09, 2001 7:26 AM

Hi Dave
That is what I put the second time around however
...it returns the wrong calculation
My values in B24:B47 are
43
42
57
80
90
89
78
74
67
74
83
82
71
76
82
83
132
50

and cell C13 counts B24:B47 which is = 18
the formula returns 994% which it should return
50%......

Posted by Aladin Akyurek on May 09, 2001 7:36 AM

Try:

=IF(C18,(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90"))/C18,0%)

Format the cell of this formula by clicking on the icon fot Percent Style.

==============

Posted by Mark W. on May 09, 2001 7:41 AM

% operator is unnecessary

Posted by Patrick on May 09, 2001 7:43 AM

That works......oh the hours lost on that one!!

Posted by Aladin Akyurek on May 09, 2001 7:47 AM

Patrick: Make that darn 0% just 0...

Posted by Dave Hawley on May 09, 2001 7:49 AM

Hi Dave

Hi Patrick

In that case use:

=IF(ISERROR((COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90")*1)/C13),"0%",(COUNTIF(B24:B47,">74")-COUNTIF(B24:B47,">90")*1)/C13)

and format as %

Dave