Welcome, Dan. In the other formulas, there are already 2 col V terms which
taken together, produces the resultant 1/0 array for the numeric percentage
range (eg: =71%, <=90%). In the earlier, there was only one col V term
(=91%) which hence left it "vulnerable" to Excel's interp on text/null
strings being greater than any real number.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"Dan the Man" wrote in message
...
That WORKED Max! Thank you so very much. All of the other percentage
breakdown parameters are working just fine (e.g. 71-90%, etc), without the
need for the ISNUMBER check. Interestingly I tried adding the ISNUMBER
check
to these other percentage breakdowns, just to see what would happen, and
the
result created skewing. It only seems to be necessary for the 91% or
greater
formula. I can't seem to figure out why one formula needs the ISNUMBER
check
to function appropriately and the others do not?

Max you always provide me with great solutions when my head can't seem to
figure it out............Always appreciated!

Dan