Hazarding a plunge here ..

Assuming the 35 interceding cells within Y8:BR8, ie cells other than the 11
cells specified in your discontiguous range, for eg: Z8, AD8:AK8, AM8:AV8,
etc are just blank cells

Then possibly .. this might yield what you're after, in H8:
=IF(COUNTA(Y8:BR8)=0,"",IF(COUNTIF(Y8:BR8,"R")=11, "R",IF(COUNTIF(Y8:BR8,"=85")=11,"HD",IF(COUNTIF(Y 8:BR8,"=75")=11,"D",IF(COUNTIF(Y8:BR8,"=65")=11, "C",IF(COUNTIF(Y8:BR8,49)=11,"NGP",IF(COUNTIF(Y8:B R8,"<=48")=11,"F","Undefined")))))))

H8 will return "Undefined" if your discontiguous range doesn't satisfy** any
of the 7 conditions specified. I dug these 7 conditions out of your posted
formula <g, and re-arranged it carefully to be evaluated in the correct
sequence, from left to right within the IF construct.

**For example: if all 11 cells in your discontiguous range contain numbers
between 49 to <65, what then is the desired return ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote:
I have this formula that keeps producing a "HD" in the destination cell H8
even though it reads this way...
=IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8 =""),"",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8, BQ8,BR8=49),"NGP",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ 8,BN8,BO8,BQ8,BR8<=48),"F",IF(AND(Y8,AA8,AB8,AC8,A L8,AW8,BJ8,BN8,BO8,BQ8,BR8="R"),"R",IF(AND(Y8,AA8, AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=85),"HD",IF(A ND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=75) ,"D",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8 ,BR8=65),"C")))))))

So could someone help me to understand this formula or what I might be doing
wrong.