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
