MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,"<75")/C13),"0%",(COUNTIF(B24:B47,"<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
OzGrid Business Applications

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

Thank you Aladin
That works......oh the hours lost on that one!!
Also thanks Dave for replying!!

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

OzGrid Business Applications

Posted by Patrick on May 09, 2001 8:00 AM

Re: Patrick: That darn % is out of there..thanks Mark

Posted by Patrick on May 09, 2001 8:14 AM

dave
I have use for what you just gave me....next step
done....thanks again